Deck 3: Data Mining and Data Warehousing Frequently

Question 1

............................. is the process of finding a model that describes and distinguishes data classes or concepts.

A)data characterization
B)data classification
C)data discrimination
D)data selection

Answer 1

data characterization

Question 2

The full form of KDD is ..................

A)knowledge database
B)knowledge discovery database
C)knowledge data house
D)knowledge data definition

Answer 2

knowledge database

Question 3

The out put of KDD is .............

A)data
B)information
C)query
D)useful information

Answer 3

data

Question 4

The data is stored, retrieved and updated in ....................

A)olap
B)oltp
C)smtp
D)ftp

Question 5

An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.

A)olap
B)oltp
C)both of the above
D)none of the above

Question 6

........................ is a good alternative to the star schema.

A)star schema
B)snowflake schema
C)fact constellation
D)star-snowflake schema

Question 7

The ............................ exposes the information being captured, stored, and managed by operational systems.

A)top-down view
B)data warehouse view
C)data source view
D)business query view

Question 8

The type of relationship in star schema is ...............

A)many to many
B)one to one
C)one to many
D)many to one

Question 9

The .................. allows the selection of the relevant information necessary for the data warehouse.

A)top-down view
B)data warehouse view
C)data source view
D)business query view

Question 10

Which of the following is not a component of a data warehouse?

A)metadata
B)current detail data
C)lightly summarized data
D)component key

Question 11

Which of the following is not a kind of data warehouse application?

A)information processing
B)analytical processing
C)data mining
D)transaction processing

Question 12

Data warehouse architecture is based on .......................

A)dbms
B)rdbms
C)sybase
D)sql server

Question 13

.......................... supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting.

A)information processing
B)analytical processing
C)data mining
D)transaction processing

Question 14

The core of the multidimensional model is the ....................... , which consists of a large set of facts and a number of dimensions.

A)multidimensional cube
B)dimensions cube
C)data cube
D)data model

Question 15

The data from the operational environment enter ........................ of data warehouse.

A)current detail data
B)older detail data
C)lightly summarized data
D)highly summarized data

Question 16

A data warehouse is ......................

A)updated by end users.
B)contains numerous naming conventions and formats
C)organized around important subject areas
D)contain only current data

Question 17

Business Intelligence and data warehousing is used for ..............

A)forecasting
B)data mining
C)analysis of large volumes of product sales data
D)all of the above

Question 18

Data warehouse contains ................ data that is never found in the operational environment.

A)normalized
B)informational
C)summary
D)denormalized

Question 19

................... are responsible for running queries and reports against data warehouse tables.

A)hardware
B)software
C)end users
D)middle ware

Question 20

The biggest drawback of the level indicator in the classic star schema is that is limits ............

A)flexibility
B)quantify
C)qualify
D)ability

Question 21

............................. are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.

A)operational database
B)relational database
C)multidimensional database
D)data repository