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

Data Warehousing (May - 2017) [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 terms Source and Target with an example.

(B) What are the End User Perspectives? Explain.

(C) What is Pilot Data Mart?

(D) Explain Analytical Productivity and Response Time.

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

(A) Explain Life Cycle of Data Warehouse.

(B) Explain the ETL activities for Unstructured Text. Explain the type of data in the Unstructured Integrated Environment.

(C) Compare Active Data Warehouse and Federated Data Warehouse.

(D) Write a short note on Helper Tables in DW.

(E) How many to-many relationships can be implemented between fact and Dimensional Modelling?

(F) Explain DW 2.0 and Referential Integrity.

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

(A) What is the Total Information Quality Management Stream? Explain.

(B) Explain and Data Marts and exploration facility in detail.

(C) What is Metadata? Explain the importance of Metadata in Data Warehouse.

(D) What is Enterprise Reference Model? Explain in detail.

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

(F) Write short note on Statistical Analysis and Heuristic Analysis.

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

(A) Explain direct dump and sensing an Attack.

(B) Explain the role of Data Model in the Integrated Sector.

(C) Explain the role of ETL Data Quality Monitor.

(D) What are the different levels of the Data Model?

(E) What are the Basic Measures? What are its drawbacks?

(F) How is Data Model Constructed for Unstructured Data?

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

(A) Explain Application Data to corporate data in DW.

(B) Write a short note on Time Collapsed Data.

(C) Explain the flow of data throughout the DW Architecture.

(D) What is nonoverlapping records and continuity of data? Explain.

(E) "ETL in online mode and batch mode". Explain.

(F) Explain the relationship of ETL with metadata.

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

(A) Explain ways to create Granularity Manager?

(B) Write a short note on Workload Management and Datamart.

(C) Explain separation of transactions into Classes.

(D) Explain ETL as shock absorber in detail.

(E) What is the use of parallelization for transaction processing?

(F) How Enterprise Metadata can be created?

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

(A) What are the different roles can be performed by company in training and user support.

(B) Discuss B-tree and bitmapped indexing method in detail.

(C) Write a short note on growth and maintenance.

(D) Give reasons why the data warehouse must be backed up? How is this different from an OLTP System?

(E) What are the steps used to load dimension table before fact table? Why?

(F) Explain Physical Design process in detail.