Dr. A.P.J. Abdul Kalam University BE VIII SEM (IT) Data Mining & Warehousing [IT-841T] June 2021 Question Paper

Dr. A.P.J. Abdul Kalam University

Bachelor of Engineering

Eighth Semester Main Examination, June-2021

Data Mining & Warehousing [IT-841T]

Branch-IT

Time: 3:00 Hrs Max Marks 70

Note : 1. Attempt any five questions.

2. All question carry equal marks.

3. Answer should be precise & to be point only.

4. Assume suitable data if necessary & state them clearly.

Q.1 (a) How is a data warehouse different from a database? How are they similar to each other?

(b) Describe three data warehouse models the enterprise warehouse, the data mart and the virtual

warehouse.

Q.2 (a) Discuss system development life cycle of a data warehouse. What factors should be considered

while designing a data warehouse?

(b) Describe star schema and snowflake schema with examples.

Q.3 (a) Why most data warehouse system support index structure? Discuss methods to index OLAP data.

(b) Discuss typical OLAP operations in brief.

Q.4 (a) Define OLAP. What are the four different types of OLAP server from implementation point of

view? Explain briefly.

(b) Discuss various issues in data mining.

Q.5 (a) What do you mean by data reduction? What are the strategies of the data reduction?

(b) What is the 'Apriori Property'? How is it used by the APRTORI algorithm? What

are the drawbacks of the Apriori algorithm?

Q.6 (a) What do you mean by association rule mining? Give an example of market basket analysis from the real world.

(b) Discuss the latest trends in association rule mining.

Q.7 (a) What are the requirements of clustering in data mining?

(b) What is hierarchical clustering? Differentiate agglomerative and divisive hierarchical clustering.

Q.8 Explain briefly (Any three):-

(i) Text mining (ii) Web usage mining

(iii) Spatial mining (iv) Web structure mining

Scanned Copies:

Share This