B.C.A. (Semester (CGPA) Examination Nov/Dec-2018
INTRODUCTION TO DATA MINING WAREHOUSING
Time: 2½ Hours Max. Marks: 70
Instructions: All questions are compulsory.
Figures to the right indicate full marks.
Q.1 Choose correct alternatives: 14
the following is not a component of a data warehouse.
Metadata Current Detail Data
Component Key Summarised Data
The partition of overall data warehouse is
Data Mart Database
Data Cube All of these
The next stage to data selection in KDD process
Data Coding Data Cleaning
Data Reporting Data Visualisation
In Data warehousing, noise is referred to as
Data Repetition Complex Data
Meta Data Random Error
Any subset of a frequent set is a frequent set. This
Upward closure property
Maximal frequent set
Downward closure property
None of these
refers to the process of deriving high-quality information from text.
Text Mining Web Mining
Database Mining Spatial Mining
A data warehouse is
Contains only current data
Contains numerous naming conventions and formats
Updated by end users
Organized around important subject areas
the following is a predictive model
Association Rule Regression
Summarization Clustering
The core of the multidimensional model is the which consists
of a large set of facts and a number of dimensions.
Data Model Data Structure
Data Cube Dimension Cube
10) Confidence is nothing but subset of an association rule is the
percentage of transactions in the database that contains U Y).
True False
Page 2 of 2
SLR-CH-10
11) . Distance-related data can be mined technique.
Web Mining Unstructured Mining
Text Mining Spatial Mining
12) Spreadsheet is one of visualization technique used in data warehousing.
True False
13) 3. Data mining can also applied to data forms such as
Sequence Network
Data Stream All of These
14) Snowflakes scheme consist of multiple fact tables.
True False
Q.2 Answer the following:
What is spatial data mining? Explain in detail. 07
What is Data Cube technology? Explain in detail with different operations
used in data cube.
07
Q.3 Answer the following:
What kind of data you can mine? Explain in detail. 07
Explain different component used in data warehouse. 07
Q.4 Attempt any 14
What is data pre-processing? Why it is required? Explain different data
preprocessing technique in detail.
Explain in detail different significant trends used in data warehouse.
Q.5 Attempt any 14
What is Association Rule? What is multidimensional Association rule? Find
frequent item sets from following table. (Min_support=2/9 and
min_confidence=7
Tr. ID List of Items
T1 M1, M2, M5
T2 M2, M4
T3 M2, M3
T4 M1, M2, M4
T5 M1, M3
T6 M2, M3
T7 M1, M3
T8 M1, M2, M3, M5
T9 M1, M2, M3
Explain Data mining functionality and issues in data mining in detail.