Q.1
14 Marks(a)
Define data mining and list its features.
(b)
Give the difference between OLAP and OLTP.
(c)
Discuss the components of a data warehouse with a diagram.
Gujarat Technological UniversityWinter 2025 examination
GTU 2170715 Data Mining and Business Intelligence (DMBI) Winter 2025 Question Paper & PDF
B.E. · Computer Engineering · Semester 7 · Subject code 2170715
- Total
- 70 marks
- To pass
- 23 marks (33%)
- Duration
- 2.5 Hours 10:30 AM – 1:00 PM
- Questions
- 5 with internal choice
No solutions on this paper yetNeed them for your exam? Ask once. Papers that students ask for are solved first, and we aim to add them within 24 hours.
Noted. This paper is in our queue now. Check back tomorrow.
We could not record that here. Email the paper name to hirenjsca@gmail.com and we will add it.
Q.2
14 Marks(a)
Define Business Intelligence and explain its relation to Data Warehousing.
(b)
Illustrate how drill-down and roll-up operations are performed on a cube.
(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.
OR
(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.
Q.3
14 Marks(a)
Define noisy data and give examples of noise in datasets.
(b)
Define data cleaning and explain its role in preprocessing.
(c)
Draw and explain KDD process.
OR
(a)
Define missing values, and state common techniques to handle them.
(b)
Discuss concept hierarchies and their importance in OLAP and Data Mining.
(c)
Discuss the key issues and challenges in Data Mining.
Q.4
14 Marks(a)
Define the following terms:
i)Classification
ii)Prediction
(b)
Explain linear regression with suitable example.
(c)
Write and explain Apriori algorithm with suitable example.
OR
(a)
Explain the term attribute relevance in data mining.
(b)
Explain market-basket analysis with example.
(c)
Describe CART algorithm to generate decision tree.
Q.5
14 Marks(a)
Briefly explain web mining.
(b)
Explain four V of Big Data.
(c)
Draw and explain data analytics life cycle.
OR
(a)
State one example of data mining application in banking & finance.
(b)
Discuss Clickstream Mining for e-commerce businesses and its benefits.
(c)
Draw and explain architecture of Hadoop.
More Data Mining and Business Intelligence papers
Questions repeat across sessions. Working through two or three papers shows you which topics GTU asks most.
Other Semester 7 subjects
BE Computer
Preparing with friends?
Send this paper to your class group. Every question has its own link.
About this paper
Official Gujarat Technological University (GTU) examination paper 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.