Download AKTU (Dr. A.P.J. Abdul Kalam Technical University (AKTU), formerly Uttar Pradesh Technical University (UPTU) B-Tech 6th Semester (Sixth Semester) 2018-2019 RIT062 Data Warehousing And Data Mining Question Paper
Papma- wa \ i i i i i i i i i
B TECH
(SEM VI) THEORY EXAMINATION 2018-19
DATA WAREHOUSING AND DATA MINING
T ime: 3 Hours T otal Marks: 70
Note: 1. Attempt all Sections.
1.
2.
SECTION A
Attempt all questions in brief. 2 x 7 = 14
a. Define Data Mining?
b. What is classification?
0. Explain data generalization.
(1. Why is data preprocessing required?
e. Define data compression?
f. Explain Association rules.
g. What is backup and recovery?
SECTION B
Attempt any three of the following: 7 x 3 = 21
a. Explain data cleaning and phases of data cleaning.
b. What are the various requirements of clustering in data mining?
c. How does a Snow?ake schema differ from a STAR schema?
(1. Define the terms?- Aggregation, Historical Information and Query Facility.
e. What is data warehousing with its advantages and disadvantages?
SECTION C
Attempt any one part of the following: 7 x 1 = 7
(a) Explain data integration, transformation and loading.
(b) Define data reduction? Write down the various strategies for data reduction.
Attempt any one part of the following: 7 x 1 = 7
(a) Find out the mean, variance and standard deviation for the height of animals
555mm,450mm,165mm,410mm and 300mm.
(b) Explain attribute relevance analysis with example.
Attempt any one part of the following: 7 x 1 = 7
(a) How CURE is different from CHAMELEON.
(b) Explain Density?based and Grid?based clustering methods.
Attempt any one part of the following: 7 x 1 = 7
(a) Write down the difference between OLTP and OLAP.
(b) Explain various architectures of data warehouse.
Attempt any one part of the following: 7 x 1 = 7
(a) Explain web mining and types of web mining with example.
(b) What are the essential differences between the ROLAP and MOLAP?
lIPage
This post was last modified on 29 January 2020