Total No. of Questions 18] [Total No. of Pages 02
M.Sc. DEGREE EXAMINATION, MAY 2018
Second Year
COMPUTER SCIENCE
Data Warehousing and Data Mining
Time 3 Hours Maximum Marks :70
SECTION A
Answer any three of the following questions. x 15 45)
Q1) Discuss three data warehouse models the enterprise warehouse, the data
mart and the virtual warehouse.
Q2) Discuss about different activities of ETL process.
Q3) Explain briefly star and snowflake schema. Also point out the major
difference between the two. Which is popular in the data warehouse
design?
Q4) Explain about oracle data warehouse builder and it works.
Q5) Discuss typical OLAP operations in brief.
SECTION B
Answer any five of the following questions. x 4 20)
Q6) What are the various Star Schema Keys? Explain with the help of an
example.
Q7) Differentiate between Data Warehouse and Data Mart.
Q8) Write about Data loading with respect to Data warehouse.
Q9) Explain Data granularity in Data Warehouse.
Q10) Describe briefly the basic components of a data warehouse snapshot.
Q11) What are the technological challenges in bringing the system-of-record data into
the data warehouse?
Q12) Describe basic algorithm for inducing a Decision tree from training samples.
Q13) What are the methods to index OLAP data?
SECTION C
Answer all of the following questions. x 1
Q14)What is ROLAP?
Q15) Define multidimensional data model.
Q16) Define association rule mining.
Q17) Give any two data mining tasks.
Q18) What is drill down analysis?