Birla Institute of Technology %28BIT Mesra%29 2006 DATA WARESHOUSING - Question Paper

Birla Institute of Technology & Science, Pilani

Distance Learning Programmes Division

Second Semester 2006-2007



Mid-Semester Test

(EC-1 Regular)



Course No. : SS ZG515

Course Title : DATA WARESHOUSING

No. of Pages = 1

No. of ques. = six
Nature of examination : Closed Book

Weightage : 40%

Duration : two Hours

Date of examination : 03/02/2007 (AN)

Note:

1. Please follow all the Instructions to Candidates provided on the cover page of the ans book.

2. All parts of a ques. should be answered consecutively. every ans should begin from a fresh page.

3. Mobile phones and computers of any type should not be brought inside the exam hall.

4. Use of any unfair means will outcome in severe disciplinary action.



Q.1. Why it is recommended that the data warehouse system should be separate from the operational system of the organization? (6)



Q.2. elaborate coverage fact tables and what purpose do they serve? In a grocery store sales data mart, provide the schema of promotion coverage table. Also explain its granularity and compare it with that of the sales fact table. (10)



Q.3. Compare and contrast ranging from a mini-dimension and an outrigger. (6)



Q.4. What is meant by conforming the dimensions? Why is this important in a data warehouse?

(6)



Q.5. How does a snowflake schema differ from a star schema? Name 2 advantages and 2 disadvantages of the snowflake schema. (6)



Q.6. Name any 5 kinds of activities that are part of the ETL process. Which of these are time consuming and why? (6)

Earning:   Approval pending.