BSc IT Sem VI ATKT DATAWAREHOUSING Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any two of the following: 10 marks
   • a. What is data warehouse? Discuss the advantages of data warehouse
   • b. Differentiate between data marts and Exploration What is Changed Data Capture in ETL? Explain
   • d. List the types of statistics collected for monitoring the functioning of data warehouse
2. Q2 Attempt any three of the following: 15 marks
   • a. Write short note on Spider Web Environment
   • b. Outline the factors which led to the evolution of DW 2.0 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 List and explain briefly the various data structures found in integrated Sector
   • f. What are the steps involved in processing of Unstructured data? a Attempt any three of the following: 15
   • a. Differentiate between Active and Passive Repository C b. Describe internal and external taxonomy in the unstructured DW 2.0 with the help of 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
3. Q4 Attempt any three of the following: 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 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 Discuss the different security measures employed for data warehouse
   • f. How can one sense attack on DW 2.0
4. Q5 Attempt ary three of the following: 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 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 How is the rejected data handled in ETL processing? What is ELT? List the drawbacks associated with it 15 marks
5. Q6 any three of the following: 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? How is Analytical environment different from Transactional Environment?
   • d. between Farmers and Explorers of data in DW 2.0 scenario How can Enterprise Metadata can be created Explain briefly the different ways in which Data Warehouse can be migrated to
6. Q7 Attempt any three of the following: 15 marks
   • a. Explain the physical design process briefly with the help of a diagram What are the different components of physical model? 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? List any five factors which are to be part of ETL management

Read from the scan above, so a character or two may differ. The scan is the original.