Download JNTU Anantapur (Jawaharlal Nehru Technological University Anantapuramu) MBA 2017 November Third Semester (3rd Semester/1-2) Regular & Supplementary Examinations 14E00319 Data Warehousing & Mining Question Paper.
MBA III Semester Regular & Supplementary Examinations November/December 2017
DATA WAREHOUSING & MINING
(For students admitted in 2014, 2015 & 2016 only)
Time: 3 hours Max. Marks: 60
PART ? A
(Answer the following: (05 X 10 = 50 Marks)
*****
1 How can you evaluate database technology?
OR
2 Explain how to organize the data warehousing in data management.
3 Explain the data sharing between functional units and different levels of users.
OR
4 Explain database system in data warehousing.
5 (a) Explain how a relational database can be organized for a data ware house.
(b) Explain four levels of data in data warehouse environment with example.
OR
6 (a) What is data cleaning? Why is it necessary?
(b) How to choose the right database structure for a data ware house? Explain.
7 What are the four types of data that the data warehouse architecture must specify? Explain.
OR
8 (a) What are the three basic elements of a project plan? Explain it.
(b) Explain how a OLAP analysis might proceed.
9 What is data cleaning? Why is it necessary? Explain it.
OR
10 What situation, where data transformation would be necessary in preparing data to be loaded into a
data warehouse?
PART ? B
(Compulsory question, 01 X 10 = 10 Marks)
11 Case study:
You have decided to prepare a budget for next 12 months on your actual expenses for the past
12 months. You need to get your expense information into what is in effect.
Questions:
(a) What are your information sources for this data warehouse?
(b) Describe how you would carry out each of the five steps of data preparation for a data
warehouse, from extraction through summarization. If a particular step does not apply, say so
and justify your statement.
*****
FirstRanker.com - FirstRanker's Choice
This post was last modified on 03 January 2020