Data Warehousing (April – 2017) [CBSGS - 75:25 Pattern | Question Paper]

Data Warehousing (April – 2017) [CBSGS - 75:25 Pattern | Question Paper]

☛ VIEW:
@SlideShare | @Instagram | @Pinterest

☛ DOWNLOAD:
@PDF | @GitHub | @G-Drive | @TEXT | @Torrent

Time: 2 ½ Hours
Total Marks: 75

NOTE:
(1) All Question are Compulsory.
(2) Make Suitable Assumptions Wherever Necessary And State The Assumptions Made.
(3) Answer To The Same Question Must Be Written Together.
(4) Number To The Right Indicates Marks.
(5) Draw Neat Labeled Diagrams Wherever Necessary.
(6) Use of Non-Programmable Calculator is allowed.

Q.1 Attempt Any Two Questions: (10 Marks)

(A) What are the characteristics of a Data Warehouse?

(B) Differentiate OLTP and OLAP.

(C) Explain the different types of facts in a fact table with suitable examples.

(D) Differentiate Star and Snowflake Schema with respect to Data Warehouse.

Q.2 Attempt Any Two Questions: (10 Marks)

(A) Why is it necessary to configure a listener before creating the Database? Explain the steps to configure a listener.

(B) What are the different components of OWB? Illustrate the same with a neat diagram.

(C) Explain the three windows in the OWB Design Center.

(D) What is the role of a DSN? What are the steps involved in configuring a DSN?

Q.3 Attempt Any Two Questions: (10 Marks)

(A) Why is it necessary to create a target user and a target module while designing a DW in OWB?

(B) Differentiate Relational and Multidimensional implementation of a Dimensional Model in a Database.

(C) Why Time Dimension is considered a key part of most Data Warehouses? Explain the different characteristics of a dimension that has to be defined in an OWB.

(D) What are the Cube Details that can be seen for a cube in the Data Object Editor?

Q.4 Attempt Any Two Questions: (10 Marks)

(A) What is the significance of ETL while creating a Data Warehouse in OWB? How is this accomplished in OWB?

(B) Explain how an Aggregator data flow operator is used in mapping between sources and targets in OWB.

(C) Discuss in detail the constraints tab in the Data Object Editor in OWB.

(D) What is the role of a Joiner data flow operator in mapping sources and targets in OWB?

Q.5 Attempt Any Two Questions: (10 Marks)

(A) Explain any three transformations operator in OWB.

(B) Why is a Key Lookup operator necessary in a mapping in OWB?

(C) Why is it important to validate the objects in a Design Center? What are the possible results after validation process?

(D) What are the default operating modes the mapping code can run in when executing in the database?

Q.6 Attempt Any Two Questions: (10 Marks)

(A) What is the significance of Snapshot in OWB?

(B) Why is it necessary to synchronize objects in OWB?

(C) Explain the terms Data Sparsity and Data Explosion with respect to a Data warehouse.

(D) Explain with a neat diagram the basic OLAP System Architecture.

Q.7 Attempt Any Three Questions: (15 Marks)

(A) Explain Slowly Changing Dimension with a suitable example.

(B) What are the steps involved in configuring repository and workspaces in OWB?

(C) What are the Dimension Details that can be seen in the Data Object Editor?

(D) List the properties seen in the property window of Aggregator operator.

(E) Explain the columns in Object Details window under the Control Center Manager window in OWB.

(F) What is the role of Recycle Bin in OWB? Explain.