Data Warehousing (October – 2016) [IDOL - Revised Course | Question Paper]

Data Warehousing (October - 2016) [IDOL - Revised Course | Question Paper]

☛ VIEW:
@SlideShare | @Instagram | @Pinterest

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

Time: 3 Hours
Total Marks: 100

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 Data Warehouse and Optional Database.

(B) Explain the terms "Source" and "Target".

(C) Explain about the process of Data Transformation.

(D) Write a short note on Monitoring of DW2.0 Environments.

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

(A) Briefly discuss the evolution of Data Warehouse.

(B) Explain about the star schema approach and its limitation.

(C) Differentiate between Data Warehouse and Data Mart.

(D) Explain in brief Interactive Sector.

(E) Explain about the Life Cycle Of Data in Data Warehouse.

(F) Explain Near Line Sector with its feature.

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

(A) Explain with reference to Data Warehouse: "Data Inconsistencies are removed; data from diverse operational applications is integrated".

(B) What is metadata? Explain about different types of metadata.

(C) Why most data warehouse systems support index structures? Discuss methods to index OLAP Data.

(D) Explain in detail the components of Infrastructure Management System.

(E) Explain about Spiral Methodology.

(F) Write a short note on Taxonomy.

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

(A) List and explain activities of ETL Process.

(B) What is a Seven Stream Approach? Explain along with limitation.

(C) Explain about Dormant Data, and how does it affect the performance.

(D) "Data Warehouse is an environment, not a product" Comment.

(E) Explain the different levels of Data Model.

(F) What are the Basic Security Measures? Explain about its drawbacks.

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

(A) Explain the importance of Data Cleaning in Data Warehouse.

(B) What is a Data Mart? Differentiate between Dependent an Independent Data Marts.

(C) Explain about Time Collapsed Data.

(D) Write a short note on Exception Based Flow of Data.

(E) Explain the relationship of ETL with Metadata.

(F) What is the difference between Local and Global Warehouses?

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

(A) Explain Data Granularity and how it is applicable to the Data Warehouse.

(B) Explain about Bit-Map indexing in detail.

(C) Write a short note on Data Accuracy Vs Data Quality.

(D) How migration of DW does is achieved? Explain.

(E) "ETL works as a shock absorber". Explain.

(F) Write a short note on Workload Management.

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

(A) How are "Data Warehouse" different from a "Database"? How are they similar?

(B) Discuss about the concept of Data Warehousing and the Web.

(C) Discuss B-Tree and Bitmapped indexing method in detail.

(D) What is Data Partitioning? How does it help in Data Warehousing Environment?

(E) Write a short note on Data Array.

(F) Write a note on Backup and Recovery during Data Warehouse Deployment.