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

Questions asked in this paper

1. Q1 Attempt of the following: 10 marks
   • a. Differentiate between operational system & informational system
   • b. What is the role of metadata management layer and data integration layer in data
   • c. Explain star schema with suitable diagram
   • d. What are additive, semi-additive and non-additive measures?
2. Q2 Attempt of the following: 10 marks
   • a. With the help of a neat diagram, explain Oracle Warehouse Builder (OWB)
   • b. Write the steps to create database using ‘Database Configuration Assistant’
   • c. Explain the various recovery options available in recovery configuration dialog box of
   • d. Write the steps to import metadata from oracle database tables
3. Q3 Attempt of the following: 10 marks
   • a. | Why dimensional model is more suitable than normalized model of database for data
   • b. What is module? Explain source module and target module
   • c. List and explain the steps for creating dimension with a dimension wizard
   • d. Explain various properties of dimension
4. Q4 Attempt any two of the following: 10 marks
   • a. What are the considerations we can take into account when deciding whether to use staging area or nor for our source data?
   • b. Enlist and explain various windows available in mapping editor
   • c. Explain the following OWB operators
   • (i) Table operator Write the steps to connect source to target using joiner operator with suitable example
5. Q5 Attempt any two of the following: 10 marks
   • a. What is validation? Difference between validation from the data object editor and validation from the mapping editor Write the steps to add Key Lookup operator
   • c. Explain the use of external table operator with suitable example note on object details window
   • Q.P. Code: 36138
6. Q6 Attempt of the following: 10 marks
   • a. Write a short note on metadata change management
   • b. is snapshot? Write the steps to take a snapshot of a table
   • c. Explain data sparsity and data explosion
   • d. Explain multidimensional database architecture with suitable diagram
7. Q7 Attempt any three of the following: 15 marks
   • a. What is listener? Write the procedure to create a new listener
   • b. | What are the factors needed to be considered while designing data warehouse?
   • c. List and explain the steps for creating a cube with using wizard
   • d. Write the steps for building staging area table using data object editor
   • e. Explain SUBSTR function of transformation operator
   • f. Write short notes on
   • (i) Parallelization

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