Amrita Vishwa Vidyapeetham 2007 M.C.A Data Warehousing - Question Paper

M.C.A. Dec 2007
Data Warehousing
Time : 3 hours Maximum : 100 marks
ans any 5 ques..
All ques. carry equal marks.
(5 ? 20 = 100)
1. (a) Compare and explain about Data mining versus query tools.
(b) What is data warehouse? discuss why do we need it?
2. (a) Discuss about the knowledge discovery process in detail.
(b) Discuss about the visualization techniques.
3. (a) Explain the preliminary analysis of the data set using traditional query tools.
(b) Discuss about the OLAP tools.
4. (a) Explain Load manager architecture.
(b) Explain how can you design the starflake schema.
5. (a) Explain the vertical partitioning.
(b) Discuss about sizing the partitioning.
6. (a) Discuss about the client hardware architecture.
(b) Describe the Database layout.
7. (a) Discuss in detail about the security impact on Design.
(b) Discuss about the Back up strategies.
8. (a) Discuss about accessing performance before tuning the data warehouse.
(b) Describe the features of Data warehouse.

Earning:   Approval pending.