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

Internet Technologies (December - 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 Question: (10 Marks)
(A) What is Data Warehouse?
(B) Write a short note on Information Quality Management.
(C) Briefly explain Business Analyst Perspective.
(D) What is Data Warehouse? List and explain the characteristics of Data Warehouse.

Q.2 Attempt Any Three Question: (15 Marks)
(A) Differentiate between Operational System and Informational System.
(B) List and explain the characteristics of Data Warehouse.
(C) Write a short note on Integrated Sector.
(D) What are Data Marts?
(E) What are Components of Data Warehouse Environment?
(F) Explain Evolution of Data Warehouse from the Business Perspective.

Q.3 Attempt Any Three Question: (15 Marks)
(A) Write a short note on Enterprise Metadata.
(B) Write a short note on Metadata.
(C) Explain Enterprise Reference Model in brief.
(D) How Data Correction Stream works?
(E) What is Spiral Model Methodology?
(F) Write a short note on Heuristic Analysis.

Q.4 Attempt Any Three Question: (15 Marks)
(A) Write a short note on Corporate Data Model.
(B) Briefly explain Peak Period Processing.
(C) Write a short note on Firewall.
(D) Write a short note on Dormant Data.
(E) How to Monitor Data Quality?
(F) What is a Summarized Data?

Q.5 Attempt Any Three Question: (15 Marks)
(A) Explain in brief Continuous Time Span Data.
(B) Write a short note on Non-Overlapping Records.
(C) Explain throughput with respect to ETL.
(D) Explain ETL in Online Mode.
(E) Explain how Data Flows into Integrated Sector.
(F) Write a short note on ETL Mapping.

Q.6 Attempt Any Three Question: (15 Marks)
(A) What are functions of Granularity Manager?
(B) Write a short note on Filtering Data.
(C) How Transaction Processing can be Parallelized?
(D) Define Online Response Time.
(E) Write a short note on Building the Metadata Infrastructure.
(F) Write a short note on workload Management.

Q.7. Attempt Any Three Question: (15 Marks)
(A) Write a short note on need of Data Warehouse.
(B) How DW is implemented on Database Systems?
(C) How data is deployed in Data Warehouse?
(D) Explain maintenance of Data Warehouse.
(E) Explain in brief Physical Design Process.
(F) Write a short note on growth of DW.