M.B.A. DEGREE EXAMINATION, APRIL 2018
Third Semester
Business Analytics
DBMS AND DATA WAREHOUSING
(2016 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 X 2 20)
Answer all questions.
1. What is the purpose of database management system?
2. What are the properties of transaction?
3. What is data warehousing?
4. Define Data mart.
5. What are facts?
6. What are the two general categories of data stored in
source operational system?
7. Define MOLAP.
8. What is market basket analysis?
9. List the four activities during data warehouse deployment.
10. What are the responsibilities of training administrator?
Sub. Code
31
CP-8789
2
Wk 14
Part B X 5 25)
Answer all questions.
11. Elaborate on object oriented database.
Or
Describe the relational model.
12. Write the properties of data in a data warehouse.
Or
Brief on critical success factors of Data warehouse.
13. Discuss on dimensional modeling.
Or
Give importance of data quality in data
warehousing.
14. Write the role of Data warehousing on web
applications.
Or
Briefly describe the cluster detection technique.
15. Describe the procedure for user acceptance.
Or
How do statistics help in fine-tuning the data
warehouse?
CP-8789
3
Wk 14
Part C X 10 30)
Answer all questions.
16. Explain parallel and distributed databases.
Or
Write short notes on architecture of data
warehouse.
17. Discuss on ETL Tools.
Or
Describe in detail about Data Visualization.
18. List and explain Business Intelligence Applications.
Or
Explain the growth and maintenance of data
warehouse.
————————