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

Birla Institute of Technology and Science, Pilani
Distance Learning Programmes Division
MS Software Engineering in Collaboration with Wipro Technologies
Second Semester 2006 – 2007
Mid-semester exam
Regular
Course No. : SEWP ZG514
Course Name : Data Warehousing
Nature of examination : Closed Book Bangalore
Weightage : 40 %
Duration : two Hours No of pages : 1
Date : March 11, 2007 (FN) No. of questions : 4

Note: Attempt all ques.. begin every ans from a fresh page

I a. explain the two forms of storing the info in any
organization. discuss their importance. 5 Marks
b. discuss the functioning of Data Staging Area of DW
5 Marks

II a. define the different metadata used in DW four Marks
b. explain the different steps used in the design of dimensional modeling with an example 6 Marks

III a. What do you understand by causal dimension? provide an
example. 4 Marks
b. What do you mean by factless fact table ? Create a factless
fact table for counting the number of people who have deposits from various branches of a bank. 6 Marks

IV a. What do you mean by GMROI ? explain the importance of
GMROI in an inventory model 5 Marks
b. Create dimensioning model for an automobile industry for
the grain “ various cars sold under various promotions”. Business analyzer should be able to generate the subsequent reports:
i. max number of cars belonging to a particular model sold
ii. model wherein the maximum accidents occurred
5 Marks

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

Earning:   Approval pending.