Data Warehousing (April – 2014) [CBSGS - 60:40 Pattern | Question Paper]

Data Warehousing (April - 2014) [CBSGS - 60:40 Pattern | Question Paper]

☛ VIEW:
@SlideShare | @Instagram | @Pinterest

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

Time: 2 ½ Hours
Total Marks: 60

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 Question: (10 Marks)

(A) What is Data Warehouse? List and explain the characteristics of the data warehouse.

(B) Explain the additive, Semi-Additive and Non-Additive Measures with examples.

(C) What are the various levels of Data Redundancy in the Data Warehouse?

(D) Differentiate between Operational System and Informational System.

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

(A) What is Listener? Write a procedure to create a listener.

(B) Explain the procedure for defining source metadata manually with Data Object Editor.

(C) Write a procedure to create a new project in OWB. What is the difference between a module and a Project?

(D) Draw and explain OWB Architecture with suitable diagram.

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

(A) Write a short note on Cube and Dimensions.

(B) Explain the steps for importing the Metadata for a flat file.

(C) What is a Module? Explain Source Module and Target Module.

(D) List and explain the functionalities that can be performed by OWB in order to create a Data Warehouse.

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

(A) What is the Staging Area? What are advantages and disadvantages of Staging?

(B) List and explain the use of various Windows available in Mapping Editor.

(C) Explain the various OWB Operators.

(D) Write the steps for Building Staging Area table using Data Object Editor.

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

(A) Write the steps to Add Primary Key for columns of a table in Data Object Editor with suitable example.

(B) Write a short note on Control Center Manager.

(C) Write the steps for validating and generating in Data Object Editor.

(D) Write a short note on ETL Transformation.

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

(A) Explain Multi-Dimensional Online Analytical Processing (MOLAP).

(B) Write a short note on:

     (i) Metadata Snapshots

     (ii) The Import Metadata Wizard

(C) Explain Multidimensional Database Architecture with suitable diagram.

(D) Explain OLAP Terminologies.