The document is an exam paper for the Data Warehouse and Data Mining course for BCA students, detailing the structure and types of questions to be answered. It includes sections on data preprocessing, OLAP, knowledge discovery, data warehousing, and various data mining techniques like classification and clustering. Students are required to attempt three questions, including a compulsory one, with a maximum score of 75 marks.
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
0 ratings0% found this document useful (0 votes)
12 views2 pages
DWH 2020
The document is an exam paper for the Data Warehouse and Data Mining course for BCA students, detailing the structure and types of questions to be answered. It includes sections on data preprocessing, OLAP, knowledge discovery, data warehousing, and various data mining techniques like classification and clustering. Students are required to attempt three questions, including a compulsory one, with a maximum score of 75 marks.
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
You are on page 1/ 2
Ms1-BA
‘(lease write your Exam Roll No.) Exam Roll No. ....
END TERM EXAMINATION
‘Sixt Semester [BCA] SEPTEMBER- OCTOBER 2020
ject: Data Warehouse and Data Mining
Maximum Marks: 75
| __ Note: Attempt any three questions including Q.nol which is compuisory. _|
Qi Answer of the following questions briefly: (5x5=25)
a) What is data preprocessing? Why it is important?
b) Differentiate between predicitve model and descriptive model.
¢) Discuss online analytical processing (OLAP) along with its types.
4) Is support and confidence for X->Y the same as that of YX? Why or why
not?
¢) What is frequent pattern mining? What is it useful for?
UNIT-1
Q2 a) —_ Explain Knowledge Discovery in Databases (KDD) prdcess in detail
with the help of a diagram. (12.5)
: b) Explain Data Staging Process in brief. How, attribiite,; sub-set
selection is performed during data staging process. wh, (12.5)
OR 7
Q3 a) In real world data, tuples with missing values for some attributés ‘are a
common ‘occurrence. Describe various methods for handling this
problem, (12,5)
>) Explain normalization, its need and various ways in which it can be
performed. (12.5)
UNIT-I
Q4 a) What is a data warehouse? Explain the architecture of data warehouse
with the help of a diagram, (12.5)
b) What are the various input sources for data? (22.5)
OR ie
Ils
Q5 a) Apriori algorithm uses an iterative approach called _level-wise
search. Explain with the help of an example. (12.5)
b) Explain, how Apriori algorithm helps in identifying association? Use
example, (12.5)
‘UNIT-IIE
Q6 a) Explain classification along with the decision tree induction algorithm, !
(12.5)
b) Explain info-gain and split criteria. (12.5)
OR
Q7 a) __Discuss K-means Clustering algorithm in detail (12.5)
b) Explain various types of data in cluster analysis, (12.5)
P.T.OO38
9
ta
UNIT-IV
a) Suppose that you are employed as a data mining analyst for a retail
company. Describe how data mining can help the company by giving specific
examples of how techniques, such as association and clustering can_ be
applied and can be used in decision making. (12.5)
b) Explain Roll-up, drill-down, slicing, dicing and pivot using suitable
example. (12.5)
OR
a) Write short note on mining spatial and multimedia databases.
(12.5)
b) How the mining of world wide web is performed? Discuss its
various applications. (12.5)