CS614 Data Warehousing Final paper 23 February 2013

Total Questions: 52

Total Marks: 80

Total MCQs: 40 (Each of 1 Mark)

Total Short Questions: 4 (Each of 2 Mark)

Total Short Questions: 4 (Each of 3 Mark)

Total Long Questions: 4 (Each of 5 Mark)  


1. Horizontal splitting of tables

2. Nested loop join and its variants

3. Hash based join and its working

4. Define DWH, data mining & knowledge discovery in database

5. Kimball’s life cycle model

6. Why should companies entertain students to visit their company’s place?

7. Static & dynamic attributes and examples from agriDWH

8. Write SQL to fetch total number of female students registered in BS telcom (5 marks)

9. Is it possible to have erroneous data in DWH? How this will impact business processes? (5 marks)

10. How is hardware utilization different in DWH? (2 marks)

11. In case of non uniform distribution, what will be the impact on performance? (5 marks)

12. Why pilot project methodology is highly recommended in DWH?