B.Sc. (Data Science) SEM III 2022 2023 Oct 2023 DATA WAREHOUSING AND MINING Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any three of the following: 15M
   • a. What is data warehousing? Explain the need of data warehousing
   • b. Define the features of data warehousing
   • c. How to implement hardware and software parallel processing?
   • d. Explain the components of the Data warehouse
   • e. What is metadata and why is it important?
   • f. What is data mart? Explain the difference between data warehouse and data marts
2. Q2 Attempt any three of the following: ISM
   • a. What is Dimension modeling? Explain benefits of dimension modeling
   • b. Define Star Schema. what is inside the dimension table
   • c. Write note on:
3. Q1 Primary Keys
   • d. What is a snowflake schema? Explain its advantages and disadvantages
   • e. Define the basic steps of data transformation
   • f. What do you mean by data loading? Aiso explain four modes of it
4. Q3 Attempt any three of the following:
   • a. Explain the concept of data mining with its applications
   • t. Explain the process of Data Mining
   • c. Differentiate between Data Mining and Machine Learning
   • d. Define classification With the working of classification
   • e. What is data preprocessing? its methods
   • f. What explained in brief?
5. Q4 any three of the following: 15M
   • a. Explain the applications of cluster analysis
   • b. Explain the working of HITS Algorithm
   • c. What is K-means clustering? Explain working of the K-means algorithm
   • d. Calculate page rank of below ‘web pages. Assume initial damping factor (d) is 0.7 21 WAREHOUSING AND MINING 75 M 2% HRS
   • e. Explain the concept of Web Content mining
   • f. Explain the working of search engines
6. Q5 Attempt any three of the following: 15M
   • a. Explain the concept of Association Rule Mining
   • b. Explain the working of Naive algorithms
   • c. Write note on:
7. Q1 Simple Storage
   • d. Explain the Apriori algorithm
   • e. What is the FP-Growth algorithm?
   • f. Consider the sales database given below
8. Q1 Support(Bread)
9. Q5 Support(Jam)

Read from the scan above, so a character or two may differ. The scan is the original.