B.C.A. (Semester (CGPA) Examination Oct/Nov-2017
INTRODUCTION TO DATA MINING WAREHOUSING
Day Date: Thursday, 16-11-2017 Max. Marks: 70
Time: 10.30 AM to 01.00 PM
Instructions: All questions are compulsory.
All questions carry equal marks.
Q.1 Choose the correct alternatives: 14
is a subject-oriented, integrated, time-variant, nonvolatile collection
of data in support of management decisions.
Data Mining Data Warehousing
Web Mining Text Mining
The data Warehouse is
read only write only
read write only None
The time horizon in Data warehouse is usually
1-2 years 3-4 years
5-6 years 5-10 years
describes the data contained in the data warehouse.
Relational data Operational data
Metadata Informational data
predicts future trends behaviors, allowing business mangers to
make proactive, knowledge-driven decisions.
Data warehouse Data mining
Datamarts Metadata
databases are owned by particular departments or business groups.
Informational
Operational
Both Informational and Operational
Flat
The star schema is composed of fact table.
One Two
Three Four
Record cannot be update in
OLTP Files
RDBMS Data warehouse
is a good alternative to the star schema.
Star schema Snowflake schema
Fact constellation Star-snowflake schema
10) Data transformation includes
A process to change data from a detailed level to a summary level.
A process to change data from a summary level to a detailed level.
Joining data from one source into various sources of data.
Separating data from one source into various sources of data.
Page 2 of 2
SLR-CD-20
11) Fact tables are
Completely demoralized Partially demoralized
Completely normalized Partially normalized
12) is the goal of data mining.
To explain some observed event or condition.
To confirm that data exists
To analyze data for expected relationships.
To create a new data warehouse.
13) Query tool is meant for
Data acquisition Information delivery
Information exchange Communication
14) Classification rules are extracted from
Root node Decision tree
Siblings Branches
Q.2 What is data warehouse metadata? 07
Explain the differences between star and snowflake schema. 07
Q.3 List the characteristics of a data ware house. 07
Compare OLTP and OLAP Systems. 07
Q.4 Attempt the following. (Any two) 14
What is mean by audio data mining?
Differentiate between fact table and dimension table.
What is descriptive and predictive data mining?
Q.5 Attempt the following. (Any two) 14
What is the need for preprocessing the data?
What is dimensionality reduction?
What is data cleaning?