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

Data Warehousing (April - 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) What are Operational Databases? Explain the basic characteristics of Data Warehouse.

(B) Describe Virtual Data Warehouse and Central Data Warehouse.

(C) Explain the various types of additivity of facts with examples.

(D) Explain Star Schema Model with the help of diagram.

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

(A) What is a Listener? How is it configured?

(B) What is Design Center? Explain the functions of Project Explorer and Connection Explorer Windows.

(C) Explain OWB Components and architecture with diagram.

(D) Explain the various steps involved in installing Oracle Database Software.

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

(A) What is a Target Schema? How is a Target Module created?

(B) What is Time Dimension? Discuss various steps involved in creating a Time Dimension using Time Dimension Wizard.

(C) Explain the various characteristics of a dimension.

(D) Write notes on:

      (i) Slowly Changing Dimension

      (ii) Surrogate Keys

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

(A) What is ETL? Explain the importance of Source Target Map.

(B) What is staging? What are its benefits? Explain the situation where staging is essential.

(C) Briefly explain the functions of filter and joiner operators.

(D) What are Data Flow Operators? Explain the concept of Pivot Operator with example.

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

(A) What is the purpose of main attribute group in a cube operator? Discuss about dimension attributes and measures in the cube.

(B) What is Expression Operator? Explain the mapping of a date field SALE_DATE to a numeric filed DAY_CODE by applying TO_CHAR() and TO_NUMBER() functions through expression operator. The string format for TO_CHAR() function is 'YYYMMDD'.

(C) Explain the concept of validating and generating objects.

(D) What is Objet Deployment? Explain the functions of Control Center Manager.

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

(A) What is Recycle Bin? Describe the features of warehouse builder Recycle Bin Window.

(B) Explain Data Sparsity and Data Explosion.

(C) What is a Snapshot? Explain Full Snapshot and Signature Snapshot.

(D) Explain the export feature of Metadata Loader.

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

(A) Write any five significant differences between OLTP Database and Data Warehouse Database.

(B) What are the Hardware and Software requirements for installing Oracle Warehouse Builder?

(C) Explain Multidimensional implements o Data Warehouse.

(D) What are Mapping Operators? Explain any two source target mapping operators in detail.

(E) What are the two ways of Validating Repository objects in Objects Editor? Briefly explain various deploy actions of Object Details Window.

(F) What are the matching strategies for synchronizing workspace objects with its corresponding mapping operator? Explain inbound and outbound synchronization.