Q.1
14 Marks(a)
Compare data mart and data warehouse.
(b)
A data warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection of data – Justify.
(c)
What is Cuboid? Explain various OLAP operations on data cube with example.
Gujarat Technological UniversitySummer 2025 examination
GTU 3161610 Data Warehousing and Mining Summer 2025 Question Paper & PDF
B.E. · IT Engineering · Semester 6 · Subject code 3161610
- 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)
Differentiate Fact table vs. Dimension table.
(b)
briefly explain classification and prediction.
(c)
Explain the KDD process in detail.
OR
(c)
Explain the major issues in data mining.
Q.3
14 Marks(a)
Briefly discuss the need for data preprocessing.
(b)
Explain the following terms with suitable example.
1)Data Integration
2)Data Transformation
(c)
Draw the diagram and describe the architecture of a data mining system.
OR
(a)
Explain parametric and non-parametric methods of data reduction.
(b)
What is data cleaning? How to handle the missing value in data cleaning?
(c)
What is noise? Describe the possible reasons for noisy data. Explain the different techniques to remove the noise from data.
Q.4
14 Marks(a)
Briefly explain Linear and Non-linear regression.
(b)
What is market basket analysis? Explain the two measures of rule interestingness: support and confidence.
(c)
Explain the steps of the Apriori Algorithm for mining Frequent Itemsets with Candidate Generation. Use a suitable example to illustrate your answer.
OR
(a)
Discuss : training and test dataset.
(b)
What is classification? Explain classification as a two-step process with a diagram.
(c)
Explain how the accuracy of a classifier/predictor can be measured.
Q.5
14 Marks(a)
Explain text mining using example.
(b)
Write a short note on tree pruning.
(c)
Explain the working of the k-Means clustering algorithm.
OR
(a)
Write a note on web mining.
(b)
Explain the following as attribute selection measures:
i)Information Gain
ii)Gain Ratio.
(c)
Discuss Bayesian classification.
More Data Warehousing and Mining papers
Questions repeat across sessions. Working through two or three papers shows you which topics GTU asks most.
Other Semester 6 subjects
BE IT
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 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.