Birla Institute of Technology (BIT Mesra) 2006 MS Software Engineering Data Warehousing (closed book) - Question Paper

Birla Institute of Technology and Science, Pilani
Distance Learning Programmes Division
MS Software Engineering in Collaboration with Wipro Technologies
First Semester 2006 – 2007
Mid-semester exam
Regular
Course No. : SEWP ZG514
Course Name : Data Warehousing
Nature of examination : Closed Book
Weightage : 40 %
Duration : two Hours

Date : August 19, 2006 (AN)
Note: Attempt all ques.. begin every ans from a fresh page

Note: Support your answers by giving relevant examples wherever feasible
1. Explain in brief the major driving factors which are architected to support the DW. (5)
2. Explain the various processes and associated Guidelines in building Data warehouse. (5)
3. Define Cube. discuss Role of cubes in Dimensional modeling with an example.
(5)
4. Define DW? Compare OLTP and OLAP (5)
5. Explain the merits and demerits of Dimensional modeling. (5)
6. With neat diagram discuss Architecture of Data Warehousing. (5)
7. Taking an example of Library transactions discuss how you design star flake schema. (5)
8. What are Facts and Dimensions? provide the guidelines in determining facts from dimensions. (5)

*********************

Earning:   Approval pending.