Data Warehousing (December - 2018) [IDOL - Revised Course]

Data Warehousing (December - 2018) [IDOL - Revised Course]

Send Your Exam Question Paper ONOur WhatsApp Group

DOWNLOAD @

☛ PDF

☛ Text

☛ G-Drive

☛ SlideShare

Time: 3 Hours

Total Marks: 100

NOTES:
(1) All Questions 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 Calculators is allowed.

Q.1 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) What is Data Warehouse? Discuss the advantages of Data Warehouse.

(B) Differentiate between Data Marts and Exploration facility.

(C) What is Changed Data Capture in ETL? Explain.

(D) List the types of statistics collected for monitoring the functioning of Data Warehouse.

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

(A) Write short note on Spider Web Environment.

(B) Outline the factors which led to the evolution of DW 2.0.

(C) Explain in brief the Life Cycle of data in DW 2.0.

(D) List the reasons which make Metadata very important in DW 2.0 Architecture.

(E) List and explain briefly the various Data Structures found in Integrated Sector.

(F) What are the steps involved in processing of Unstructured Data?

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

(A) Differentiate between Active and Passive Repository.

(B) Describe Internal and External Taxonomy in the unstructured DW 2.0 with the help of an example.

(C) Explain key features of Spiral Development Methodology for DW 2.0.

(D) Describe Heuristic Analysis. What is freezing of data and Why is it required?

(E) What is Exploration facility? List its sources of Data.

(F) List and briefly explain the activities involved in Seven Streams Approach to DW/BI projects.

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

(A) What is a Data Model? Explain the different Levels of Data Model.

(B) Write a note on Transformation of Data Model across different Sectors.

(C) Explain briefly the types of monitors used to Monitor DW 2.0 Environment.

(D) List the various aspects of data which is examined by the ETL Data Quality Monitor.

(E) Discuss the different Security Measures employed for Data Warehouse.

(F) How can one sense attack on DW 2.0.

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

(A) Explain Discrete and Continuous time span data with an example of each. What is significance of these?

(B) What is Time Collapsed Data? Explain.

(C) What are the Three Exceptional Flow of data in DW 2.0? Explain briefly.

(D) How does ETL act in Online and Batch Mode? Discuss.

(E) How is the Rejected Data handled in ETL processing?

(F) What is ELT? List the drawbacks associated with it.

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

(A) What is Granularity Manager? List the main functions of Granularity manager.

(B) Discuss few ways in which the performance of DW environment can be improved?

(C) How is Analytical environment different from Transactional Environment?

(D) Differentiate between Farmers and Explorers of data in DW 2.0 scenario.

(E) How can Enterprise Metadata can be created?

(F) Explain briefly the different ways in which Data Warehouse can be migrated to DW2.0.

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

(A) Explain the Physical Design Process briefly with the help of a diagram.

(B) What are the different components of Physical Model?

(C) List the conditions under which Pilot Deployments are useful.

(D) Explain briefly the major activities involved in deployment of Data Warehouse.

(E) What are the three main subjects in user Training Material? Why are they important?

(F) List any five factors which are to be part of ETL Management.