BSc IT Sem VI 2016 17 2016-17 Data Warehaesing Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any two of the following: LO the ch a characteristics of a|Data Warehouse? 10 marks
   • b. Differentiate OLTP and
   • c. Explain the different types of facts ina fact table with suitable examples
   • d. Differentiate Star and Snowflake Schema with respect to Data warehouse
2. Q2 Attempt any two of 10 marks
   • a. Whyisit necessary to configure-a listener before creating the database? Explain the steps to configure
   • b. What are the different components of OWB? the same with a neat
   • c. the three OWB Design Center:
   • d. Whatis the:role.of a DSN?What are the steps involved in configuring a DSN? i
3. Q3 two:of the 10 marks
   • a. it necessary to create a target user and a target module while designing a DW
   • b. Differentiate. multidimensional implementation of a dimensional Time'dimension is considered a key part of most data warehouses? Explain the different that has to be defined in an OWB are the Cube Details that can for a cube in the Data Object Editor? Attempt.any-two of the:following: 10 fs the significance of ETL whjle creating a Data Warehouse in OWB? How is this flow operator is used in mapping between sources Discuss:in-detail the constraints tab in the Data Object Editor in OWB What:is the role of data flow operator in mapping sources and targets in
4. Q5 Attempt any two of the following:
   • a. any three is a Key Lookup operator necessary in a mapping in
   • c. is it important to validate the objects in a Design-Centere
   • d. What are the default operating modes the mapping code in the database? Attempt any two of the following:
   • a. What is the significance of in OWBR is it necessary to synchronize abjects in OWB? ala
   • c. Explain the terms Data Spargity ‘and Explosion
   • d. with a neat diagram System Architectures:
5. Q7 Attempt any three of the. following:
   • b. What are the steps repository.an Editor?
   • c. What are the Dimension Details the the properties.seen.in the ntral Center Manager the Details window under the Co window in QWB. =
   • f. What is the role‘of Recycle Bin in OWB?

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