Question 1
(a)
Define data mining and list its features.
3 Marks
(b)
Give the difference between OLAP and OLTP.
4 Marks
(c)
Discuss the components of a data warehouse with a diagram.
7 Marks
Gujarat Technological UniversityWinter 2025 Examination
GTU 2170715 Data Mining and Business Intelligence (DMBI) Winter 2025 Paper Solution & PDF
B.E. · Computer Engineering · Semester 7 · Subject Code: 2170715
Total Marks70 MarksExternal theory exam
Passing Marks23 Marks33% minimum cutoff
Exam Duration2.5 Hours10:30 AM – 1:00 PM
Paper Structure5 QuestionsWith internal OR choices
Question 2
(a)
Define Business Intelligence and explain its relation to Data Warehousing.
3 Marks
(b)
Illustrate how drill-down and roll-up operations are performed on a cube.
4 Marks
(c)
A university wants to track student enrollments, courses, and faculty details. Design a Snowflake Schema for this scenario. Explain the advantages and disadvantages of using Snowflake Schema in this case.
7 Marks
OR OPTION
(c)
A retail company wants to analyze its sales data by products, stores, and time periods. Design a Star Schema for this scenario. Describe advantages and disadvantages of Star Schema for this scenario.
7 Marks
Question 3
(a)
Define noisy data and give examples of noise in datasets.
3 Marks
(b)
Define data cleaning and explain its role in preprocessing.
4 Marks
(c)
Draw and explain KDD process.
7 Marks
OR OPTION
(a)
Define missing values, and state common techniques to handle them.
3 Marks
(b)
Discuss concept hierarchies and their importance in OLAP and Data Mining.
4 Marks
(c)
Discuss the key issues and challenges in Data Mining.
7 Marks
Question 4
(a)
Define the following terms:
i)Classification
ii)Prediction
3 Marks
(b)
Explain linear regression with suitable example.
4 Marks
(c)
Write and explain Apriori algorithm with suitable example.
7 Marks
OR OPTION
(a)
Explain the term attribute relevance in data mining.
3 Marks
(b)
Explain market-basket analysis with example.
4 Marks
(c)
Describe CART algorithm to generate decision tree.
7 Marks
Question 5
(a)
Briefly explain web mining.
3 Marks
(b)
Explain four V of Big Data.
4 Marks
(c)
Draw and explain data analytics life cycle.
7 Marks
OR OPTION
(a)
State one example of data mining application in banking & finance.
3 Marks
(b)
Discuss Clickstream Mining for e-commerce businesses and its benefits.
4 Marks
(c)
Draw and explain architecture of Hadoop.
7 Marks
College Exam Groups
Studying for Data Mining and Business Intelligence?
Circulate this solved paper with KaTeX formulas and 1-click AI step solvers to your batchmates on WhatsApp or Telegram.
About this Examination Paper & Attribution
Official Gujarat Technological University (GTU) examination paper and step-by-step solutions for Data Mining and Business Intelligence (DMBI) (Winter 2025, B.E. · Computer Engineering, Sem 7). Features complete 70-mark regular & remedial examination pattern, official marking distribution across all 5 questions, and direct 1-click official PDF download.
Transcribed for student exam preparation from Gujarat Technological University official examination archives. Questions, syllabus guidelines, and curriculum marking schemes remain the intellectual property of Gujarat Technological University.