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

Data Warehousing (October - 2015) [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) Differentiate between Star Schema and Snowflake Schema.

(B) Explain Slowly Changing Dimensions (SCD) and its type with example.

(C) List and explain the characteristics of Data Warehouse.

(D) Differentiate between Operational System and Informational System.

Q.2 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) Draw and explain the OWB Architecture.

(B) Write the steps to Import Metadata from a file.

(C) What is the purpose of Design Centre? Explain the following Windows:

     (i) Project Explorer Window

     (ii) Connection Explorer Window

(D) How Source Metadata can be defined manually with Data Object Editor?

Q.3 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) Write a short note on Dimensional Modeling.

(B) What is Module? Explain Source Module and Warehouse Target Module.

(C) Differentiate between Relational Model (star schema) and Multidimensional Model.

(D) Explain the procedure for creating cube in OWB.

Q.4 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) Write a short note on ETL (Extract, Transform and Load).

(B) What is difference between Data Object Editor and Mapping Editor (Canvas)?

(C) Explain the following operators:

     (i) Cube Operator

     (ii) Dimension Operator

     (iii) External Table Operator

     (iv) Table Operator

(D) Write the steps to connect source table to target using Joiner Operator with example.

Q.5 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) Write the steps to create New Mapping and Adding Source and Target Tables.

(B) What is Transformation Operator? How is UPPER() Transformation function used?

(C) Write the procedure to create and to load a lookup table.

(D) Write the steps for validating and generating in Design Center and Mapping Editor.

Q.6 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) Write a short on Metadata Change Management.

(B) Explain Multidimensional Database Architectures with suitable diagram.

(C) What is the purpose of snapshots? Explain the steps to create a new snapshots.

(D) Explain Real-Time Analytical Processing.

Q.7 ATTEMPT ANY THREE QUESTIONS: (15 MARKS)

(A) Draw and explain Data Warehouse Architecture.

(B) List and explain the steps to configure the repository and workspaces.

(C) Explain creating a Time Dimension with the Time Dimension Wizard.

(D) What is staging in Data Warehouse? List and advantages and disadvantages of staging.

(E) Explain the Object Details Window.

(F) What is MOLAP? List and advantages of MOLAP over ROLAP.