Question 1
(a)
Difference between association and classification.
3 Marks
(b)
Difference between Star Schema and Snowflake schema
4 Marks
(c)
Explain KDD process in detail.
7 Marks
Gujarat Technological UniversitySummer 2025 Examination
GTU 2170715 Data Mining and Business Intelligence (DMBI) Summer 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 Hours2:30 PM – 5:00 PM
Paper Structure5 QuestionsWith internal OR choices
Question 2
(a)
Differentiate between data warehouse and data mart.
3 Marks
(b)
Explain Different normalization methods.
4 Marks
(c)
What is data cleaning? Explain steps for handling the missing values in database.
7 Marks
OR OPTION
(c)
Generate strong association rules for given dataset. (Min_supp = 60% and Min_conf = 80%) TID Item_bought 1 {M,O,N,K,E,Y} 2 {D,O,N,K,E,Y} 3 {M,A,K,E} 4 {M,U,C,K,Y} 5 {C,O,O,K,I,E}
7 Marks
Question 3
(a)
Explain ROLAP and MOLAP.
3 Marks
(b)
Discuss OLAP and OLTP.
4 Marks
(c)
Explain activities of data transformation.
7 Marks
OR OPTION
(a)
Explain Support and Confidence measures by taking appropriate example.
3 Marks
(b)
What is classification? Discuss phases of classification.
4 Marks
(c)
Mean, median, mode and variance and standard deviation explain with suitable example
7 Marks
Question 4
(a)
Give a list of data transformation strategies and explain any one in brief.
3 Marks
(b)
Define True Positive, True Negative, False Positive and False Negative.
4 Marks
(c)
Explain Back propagation neural network in detail
7 Marks
OR OPTION
(a)
Differentiate prediction and classification.
3 Marks
(b)
What is classification? Explain classification process.
4 Marks
(c)
Explain decision tree algorithm with suitable example.
7 Marks
Question 5
(a)
Explain role of business intelligence in market segmentation.
3 Marks
(b)
What is business intelligence? Give its advantages.
4 Marks
(c)
What is distributed file system? Explain HDFS architecture in detail.
7 Marks
OR OPTION
(a)
What is Big Data?
3 Marks
(b)
Difference between Data Mining and Text Mining
4 Marks
(c)
Write a short note on Hadoop MapReduce .
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) (Summer 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.