Download AKTU B-Tech 6th Sem 2018-2019 RIT062 Data Warehousing And Data Mining Question Paper

Firstranker's choice

Printed Pages: 01

FirstRanker.com

--- Content provided by‍ FirstRanker.com ---

Roll No.

B TECH

(SEM VI) THEORY EXAMINATION 2018-19

DATA WAREHOUSING AND DATA MINING

Time: 3 Hours

--- Content provided by​ FirstRanker.com ---

Total Marks: 70

Note: 1. Attempt all Sections.

SECTION A

1. Attempt all questions in brief. 2 x 7 = 14

1. Define Data Mining?

--- Content provided by‌ FirstRanker.com ---

2. What is classification?
3. Explain data generalization.
4. Why is data preprocessing required?
5. Define data compression?
6. Explain Association rules.

--- Content provided by⁠ FirstRanker.com ---

7. What is backup and recovery?

SECTION B

2. Attempt any three of the following: 7 x 3 = 21

1. Explain data cleaning and phases of data cleaning.
2. What are the various requirements of clustering in data mining?

--- Content provided by‌ FirstRanker.com ---

3. How does a Snowflake schema differ from a STAR schema?
4. Define the terms-- Aggregation, Historical Information and Query Facility.
5. What is data warehousing with its advantages and disadvantages?

SECTION C

3. Attempt any one part of the following: 7x1=7

--- Content provided by‍ FirstRanker.com ---

1. Explain data integration, transformation and loading.
2. Define data reduction? Write down the various strategies for data reduction.

4. Attempt any one part of the following: 7x1=7

1. Find out the mean, variance and standard deviation for the height of animals 555mm, 450mm, 165mm, 410mm and 300mm.
2. Explain attribute relevance analysis with example.

--- Content provided by‍ FirstRanker.com ---

5. Attempt any one part of the following: 7x1=7

1. How CURE is different from CHAMELEON.
2. Explain Density-based and Grid-based clustering methods.

6. Attempt any one part of the following: 7x1=7

1. Write down the difference between OLTP and OLAP.

--- Content provided by FirstRanker.com ---

2. Explain various architectures of data warehouse.

7. Attempt any one part of the following: 7x1=7

1. Explain web mining and types of web mining with example.
2. What are the essential differences between the ROLAP and MOLAP?

1 | Page

--- Content provided by FirstRanker.com ---

FirstRanker.com