Get premium membership and access revision papers, questions with answers as well as video lessons.

Data Warehousing And Data Mining Question Paper

Data Warehousing And Data Mining

Course:Bachelor Of Science In Information Technology

Institution: Masinde Muliro University Of Science And Technology question papers

Exam Year:2010

THIRD YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
DATAWAREHOUSING AND DATA MINING
DATE: DECEMBER 2010 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE
a) Define the following terms
i) Data mining (2 marks)
ii) Data Warehouse (2 marks)
iii)Online Analytical Processing (2 marks)
b) Outline the phases of decision support lifecycle (10 marks)
c) Elaborate the following schemas as used in data warehousing
i) Simple Star Schemas (2 marks)
ii)Multi-Star Schema (2 marks)
iii)Snowflake Schema (2 marks)
d) Outline the typical OLAP operations (4 marks)
e) Explain any four applications of data mining (4 marks)
QUESTION TWO
a) Outline the main challenges associated with web mining (4 marks)
b)Differentiate between k-medoids and the k-means methods in partitioning (4 marks)
c) Explain the requirements of clustering in data mining (9 marks)
d)What is the meaning of the term good clustering? (3 marks)
QUESTION THREE
a) Explain how clustering can be used in the following areas
i) Marketing (2marks)
ii) Land use (2 marks)
iii)Insurance (2 marks)
b)Outline the steps of genetic learning algorithm (4 marks)
c) Discuss how a decision tree is used as an algorithm in data mining (6 marks)
d)Using an example explain the term Information gain in the context of data mining (4 marks)
QUESTION FOUR
a) Explain the basic steps used in neural networks backpropagation learning algorithm (6 marks)
b)Using an example elaborate on the syntax of MDX (6 marks)
c)Define the term neural network (2 marks)
d)Discuss the following as used in knowledge discovery
i) Data Selection (2 marks)
ii) Cleaning (2 marks)
iii)Enrichment (2 marks)
QUESTION FIVE
a)
i) What Is Frequent Pattern Mining? (2marks)
ii) Give examples of frequent patterns (2 marks)
b)Briefly explain The Apriori Algorithm as used in pattern mining (6 marks)
c) State the four relationships in which all data within a cube is divided into as per the MDX
statements (4 marks)
d)Explain the techniques for Web usage mining (6 marks)

Data Warehousing And Data Mining Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams