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

Data Warehousing (May - 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) Explain the term Data Warehouse.

(B) What is the importance of metadata in the data warehouse?

(C) What are the two common types of transactions in data warehousing?

(D) How the data is protected in data warehouse?

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

(A) Discuss the impact of the data warehouse on business.

(B) Discuss the problems related with Federated data warehouse.

(C) Discuss the fundamental operating differences between the various sectors in data warehouse.

(D) Explain by giving example structured and unstructured data with respect to a data warehouse.

(E) What is the significance of referential integrity of the data in the data warehouse?

(F) The challenges of incorporating unstructured data with structured data in a data warehouse are many. What are they?

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

(A) Write a short note on active and passive metadata repositories in a data warehouse.

(B) Explain the term Taxonomy related to unstructured data warehouse. What are its types?

(C) Explain the role of Total Information Quality Management stream with respect to seven stream approach to data warehouse.

(D) What is meant by heuristic analysis of data in a data warehouse?

(E) Differentiate data mart and exploration facility with respect to a data warehouse.

(F) Explain data profiling and mapping stream it seven stream approach to data warehouse.

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

(A) Explain corporate data model with respect to a data warehouse.

(B) Write a short note on Transformation of Data made as data passes from the Application / Interactive Sector to the Integrated Sector?

(C) Discuss the relationship between Data Models and Unstructured Data.

(D) What is the role of data quality monitor in a data warehouse?

(E) Why is the Data Warehouse Monitor a standard recommendation for DW 2.0 environment?

(F) Write a short note on Document Data.

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

(A) Differentiate between Discrete Time-Variant Data and Continuous Time Span Time-Variant Data.

(B) How does data flow into the Integrated Sector of a Data Warehouse?

(C) Data flow into near line sector of a data warehouse is considered optional. Why?

(D) How is the term "Exception-based flow of data" associated with flow of data in a Data Warehouse?

(E) Discuss the points to be taken care of when source-to-target mapping of each unit of data has to be done to form a data warehouse.

(F) Data throughput is a major concern with ETL processing. Justify.

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

(A) How Indexing Technique helps to improve performance of a data warehouse?

(B) How is migration of unstructured data different from navigation of structured data in a data warehouse?

(C) Discuss the importance of good online response time to increase the performance of a data warehouse.

(D) What are the different functions of the granularity manager in a data warehouse?

(E) Capacity planning puts the organization in a proactive stance when it comes to performance. Justify.

(F) Parallelization of processing is a really good way to enhance performance. Justify.

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

(A) Write a short note on an Optimizing Storage.

(B) Explain with an example Data Clustering.

(C) What are the techniques to improve the performance of data warehouse?

(D) What is the advantage of using pilot systems?

(E) Explain the procedure of loading dimension tables before the fact tables.

(F) Write a short note on user acceptance procedure.