NEW
Font size
WorksheetsData mining Quiz
Total questions: 20
Worksheet time: 7mins
ETL is abbreviated as
Except, Transformation,Load
Extract,Transform,Load
Exact,Transission,Load
None of the above
Arrange the following sequence 1.Data 2.Knowledge 3.Information 4.Insight
3,1,4,2
1,3,2,4
4,1,2,3
1,2,3,4
Which of the following data modeling?
OLAP
OLTP
HOLAP
MOLAP
For "point in time" concept in DWH, history staging is must
True
False
OLTP systems are
Operating Systems
Purely Decision Support systems
Analytical Systems
Security systems
Full form of ODS
Operational data storage
Operational data system
Online data storage
None
The key which is substitution for natural primary key in data warehouse
Unique key
Natural key
Foreign key
Surrogate key
In star schema dimensional tables are usually not in BCNF form
True
False
In warehouse data is stored with bitmap index
True
False
Which of the following statements is/are true about fact data and dimensional data
1. Fact data represents a physical transaction that has occurred at the point in time and as such is unlikely change during ongoing basis during the life of data warehouse.
2. In general dimensional data in a star schema or snowflake schema is designed to minimize the cost of change and is typically very low volume data (i.e. under 5 GB)
3. Fact data will have only one foreign key whereas reference data will have one primary key.
Only 1
Only 2
Only 3
Both 1 and 2
OLTP data is the combination of master data and
Dimensional data
Aggregated data
Details data
None of the above
Arrange the following steps in the correct sequence
1. Look for essential transactions.
2. Check if the fact is a dimension.
3. Check if dimension is the fact.
4. Determine key dimensions.
1,3,2,4
4,1,3,2
1,4,2,3
1,2,3,4
Types of schemas in DWH
Star schema, Snowflake schema, 3NF
Snowflake schema, 2NF
Snowflake schema, Star schema
Star schema
Star schema stores data in form of
1NF
2NF
3NF
4NF
Which of the following is not involve in data mining?
Knowledge extraction
Data archaeology
Data exploration
Data transformation
Which is the right approach of Data Mining?
Infrastructure, exploration, analysis, interpretation, exploitation
Infrastructure, exploration, analysis, exploitation, interpretation
Infrastructure, analysis, exploration, interpretation, exploitation
Infrastructure, analysis, exploration, exploitation, interpretation
Which of the following issue is considered before investing in Data Mining?
Functionality
Vendor consideration
Compatibility
All of the above
Examples of Nominal can be:
Rankings, taste of potato chips, grades, height
ID Numbers, eye color, zip codes
Calendar dates, temperatures in celsius or fahrenheit, phone numbers
Temperature in Kelvin, length, time, counts
Record data set consists of:
Data Matrix, Document Data, Transaction Data
Generic Data, Inferential Data, Continuous Data
World Wide Web, Molecular Structures
Spacial Data, Temporal Data, Sequential Data, Genetic Sequence Data
Examples of Ordinal can be:
Temperature in Kelvin, length, time, counts
Rankings, taste of potato chips, grades, height
ID Numbers, eye color, zip codes
Calendar dates, temperatures in celsius or fahrenheit, phone numbers
