19-11-2012, 04:23 PM
CS1011 Data Warehouse and Data Mining Questions
CS1011.pdf (Size: 139.9 KB / Downloads: 119)
PART - A
1. Define Data warehouse?
2. What are operational databases?
3. Define OLTP?
4. Define OLAP?
5. How a database design is represented in OLAP systems?
6. Write short notes on multidimensional data model?
7. Define data cube?
8. What are facts?
9. What are dimensions?
10. Define dimension table?
11. Define fact table?
12. What are lattice of cuboids?
13. What is apex cuboid?
14. List out the components of star schema?
15. What is snowflake schema?
16. List out the components of fact constellation schema?
17. Point out the major difference between the star schema and the
snowflake schema?
18. Which is popular in the data warehouse design, star schema model (or) snowflake
schema model?
19. Define concept hierarchy?
20. Define Total Order?
21. Define partial order?
22. Define schema hierarchy?
23. List out the OLAP operations in multidimensional data model?
24. What is roll-up operation?
25. What is drill-down operation?
26. What is slice operation?
27. What is dice operation?
28. What is pivot operation?
29. List out the views in the design of a data warehouse?
30. List out the steps of the data warehouse design process?
31. Define ROLAP?
32. Define MOLAP?
33. Define HOLAP?
34. What is data mart?
35. What are dependent and independent data marts?
36. What is virtual warehouse?
37. Define indexing?
38. What are the types of indexing?
39. Define metadata?
PART - B
1. Discuss the components of data warehouse. (16)
2. List out the differences between OLTP and OLAP. (16)
3. Discuss the various schematic representations in multidimensional model. (16)
4. Explain the OLAP operations multidimensional model. (16)
5. Explain the design and construction of a data warehouse. (16)
6. Explain the three-tier data warehouse architecture. (16)
7. (a) Explain indexing.