UnFoldPrep
Browse Archive
Gujarat Technological UniversitySummer 2025 Examination

GTU 3161610 Data Warehousing and Mining Summer 2025 Paper Solution & PDF

B.E. · IT Engineering · Semester 6 · Subject Code: 3161610
Download Official GTU PDF
Share:
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
Jump toQ1Q2Q3Q4Q5

Question 1

14 MarksMedium
(a)
Compare data mart and data warehouse.
3 Marks
(b)

A data warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection of data – Justify.

4 Marks
(c)
What is Cuboid? Explain various OLAP operations on data cube with example.
7 Marks

Question 2

14 MarksMedium
(a)
Differentiate Fact table vs. Dimension table.
3 Marks
(b)
briefly explain classification and prediction.
4 Marks
(c)
Explain the KDD process in detail.
7 Marks
OR OPTION
(c)
Explain the major issues in data mining.
7 Marks

Question 3

14 MarksMedium
(a)
Briefly discuss the need for data preprocessing.
3 Marks
(b)
Explain the following terms with suitable example.
1)Data Integration
2)Data Transformation
4 Marks
(c)
Draw the diagram and describe the architecture of a data mining system.
7 Marks
OR OPTION
(a)
Explain parametric and non-parametric methods of data reduction.
3 Marks
(b)
What is data cleaning? How to handle the missing value in data cleaning?
4 Marks
(c)

What is noise? Describe the possible reasons for noisy data. Explain the different techniques to remove the noise from data.

7 Marks

Question 4

14 MarksMedium
(a)
Briefly explain Linear and Non-linear regression.
3 Marks
(b)

What is market basket analysis? Explain the two measures of rule interestingness: support and confidence.

4 Marks
(c)

Explain the steps of the Apriori Algorithm for mining Frequent Itemsets with Candidate Generation. Use a suitable example to illustrate your answer.

7 Marks
OR OPTION
(a)
Discuss : training and test dataset.
3 Marks
(b)

What is classification? Explain classification as a two-step process with a diagram.

4 Marks
(c)
Explain how the accuracy of a classifier/predictor can be measured.
7 Marks

Question 5

14 MarksMedium
(a)
Explain text mining using example.
3 Marks
(b)
Write a short note on tree pruning.
4 Marks
(c)
Explain the working of the k-Means clustering algorithm.
7 Marks
OR OPTION
(a)
Write a note on web mining.
3 Marks
(b)
Explain the following as attribute selection measures:
i)Information Gain
ii)Gain Ratio.
4 Marks
(c)
Discuss Bayesian classification.
7 Marks
College Exam Groups

Studying for Data Warehousing and Mining?

Circulate this solved paper with KaTeX formulas and 1-click AI step solvers to your batchmates on WhatsApp or Telegram.

Related papers

About this Examination Paper & Attribution

Official Gujarat Technological University (GTU) examination paper and step-by-step solutions for Data Warehousing and Mining (Summer 2025, B.E. · IT Engineering, Sem 6). 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.

Download PDF