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

Questions asked in this paper

• 2) Figures to the right indicate marks

1. Q3 Illustrations, in-depth answers and diagrams will be appreciated
2. Q4 Mixing of sub-questions is not allowed
3. Q5 Use of simple calculator is allowed
4. Q1 Attempt any three. [15
   • a. Explain Data Warehouse Architecture with suitable diagram Why Metadata is important? What are the different types of metadata?
   • c. What is Data Warehouse? What are different features of it?
   • e. What is Data Mart? Explain with suitable example
   • f. Write short note on Web-Enabled Data Warehouse
5. Q2 Attempt any three. 15 marks
   • a. What is Dimension modeling? Explain benefits of dimension modeling
   • b. Write short note on dimension and fact table
   • c. What is need of Data design?
   • d. is Snowflakes schema? Explain with suitable example
   • e. What is ETL? Explain different steps for ETL process \What is Star schema? Explain with suitable example
6. Q3 Attempt any three. 15 marks
   • a. \Vhat are the difference between Data Mining and Machine Learning?
   • b. Can Data Mining Do and Not Do? ce. Classification? What are different types o! Classification? are different Data Mining Techniques”
   • e. Write a short note on Weka
   • i. Naive Bayes Method with suitable example
7. Q4 Attempt any three. [15
   • a. | different characteristics of Clustering
   • b. \Whatare different applications of Cluster Analysis? Write a short note on k-means clustering
   • d. What is Manhattan distance? Consider three person located at (30,70), (40,54) and (80.50)
   • e. What is Page Rank algorithm? Calculate page rank of following web pages with damping the architecture of search engine with suitable diagram
8. Q5 Attempt any three. 15 marks
   • a. What are the different approaches for Transaction Database Storage?
   • b. Write a short note on Association Rule Mining
   • c. What is the FP-Growth algorithm? Find the association rules having minimum support of 50% and minimum confidence of 75%
   • e. Explain Apriori Algorithm
   • f. Consider the sales database given below
   • i. Support(Pencil)

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