KKR & KSR INSTITUTE OF TECHNOLOGY & SCIENCES(AUTONOMOUS)
(Approved by AICTE, New Delhi, Affiliated to JNTUK Kakinada, Accredited by NAAC ‘A’ Grade& NBA)
Regulation : R20
SUB CODE: [Link] III Year II Sem Date :
Academic Year :2023-2024
20CI6E24 Descriptive Test No: 01 Max. Time :90 Min.
CAI SUB: Data Warehousing and Data Mining Max Marks : 40M
UNIT-1
Question Marks CO TL
A) What is Data mining? Explain the steps involved in data mining process?
L1
1. (8M) 16 C322.1
B) Explain the functionalities of Data mining. (8M) L2
A) Explain the Data mining task primitives. (8M) L2
2. B) Explain the Major issues in data mining.(8M)
16 C322.1
L2
3. Discus the different phases of Data mining life cycle. (16M) 16 C322.1 L2
A) What are the data cleaning methods in data mining? (8M) L1
4. B) Write about Data integration techniques.(8M) 16
C322.1
L3
5. What are the data reduction techniques?(16M) C322.1 L1
16
UNIT-2
Question Marks CO TL
1. Explain the different schemas used in the construction of data warehouse.(16M) 16 C322.1 L2
2. Explain the data warehouse architecture in detail. (16M) 16 C322.1 L2
a) Define a Data mart? Explain the different types of data mart. (8M)
16 L1
3. b) Explain how to implement data warehouse. (8M)
C322.1
L2
A) Explain the different indexing techniques used in OLAP.(8M)
4. 16 C322.1
L2
B) What is OLAP? Explain the different types of OLAP operations. (8M) L1
5. What are the basic approaches of Data generalization? (16M) 16 C322.1 L1
UNIT -3
Question Marks CO TL
1 Explain market basket analysis. (8M) 8 C322.1 L2
Explain Apriori algorithm with an example for mining frequent 8
2 Item sets. (8M) C322.1 L2
3 Write about association rules (8M) 8 C322.1 L3