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

Accepted Answer

A

Question 2

The full form of KDD is ..................
A)knowledge database
B)knowledge discovery database
C)knowledge data house
D)knowledge data definition

Accepted Answer

A

Question 3

The out put of KDD is .............
A)data
B)information
C)query
D)useful information

Accepted Answer

A

Question 4

The data is stored, retrieved and updated in ....................
A)olap
B)oltp
C)smtp
D)ftp

Accepted Answer

OLTP (Online Transaction Processing) systems are designed for managing transaction-oriented applications. They are optimized for managing and updating data in real time, making them suitable for tasks that involve data storage, retrieval, and updating.

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

Accepted Answer

An OLAP (Online Analytical Processing) system is designed for multidimensional analysis of data in a market-oriented environment, supporting the decision-making process of knowledge workers such as managers, executives, and analysts. OLTP (Online Transaction Processing) systems, on the other hand, are designed for managing transaction-oriented applications.

Question 6

........................ is a good alternative to the star schema.
A)star schema
B)snowflake schema
C)fact constellation
D)star-snowflake schema

Accepted Answer

The answer of ........................ is a good alternative to the...

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

Accepted Answer

The data source view exposes the information being captured, stored, and managed by operational systems, as it directly relates to the origins of the data.

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

Accepted Answer

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

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

Accepted Answer

The answer of The .................. allows the selection of the...

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

Accepted Answer

The answer of Which of the following is not a...

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

Accepted Answer

Transaction processing is not a kind of data warehouse application. Data warehouses are designed for query and analysis rather than for transaction processing. They are used to consolidate data from different sources and support information processing, analytical processing, and data mining. Transaction processing systems are operational systems that record the daily routine transactions necessary to conduct the business; they are not typically used for the analytical and decision-support purposes of data warehouses.

Question 12

Data warehouse architecture is based on .......................
A)dbms
B)rdbms
C)sybase
D)sql server

Accepted Answer

Data warehouse architecture is often based on relational database management systems (RDBMS) because they provide a structured way to store, retrieve, and manage large amounts of data, which is essential for data warehousing.

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

Accepted Answer

The answer of .......................... supports basic OLAP operations, including slice...

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

Accepted Answer

The answer of The core of the multidimensional model is...

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

Accepted Answer

The data from the operational environment typically enters the data warehouse as current detail data, which is then processed and transformed for analysis and reporting.

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

Accepted Answer

The answer of A data warehouse is ......................
A)updated by end...

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

Accepted Answer

The answer of Business Intelligence and data warehousing is used...

Question 18

Data warehouse contains ................ data that is never found in the operational environment.
A)normalized
B)informational
C)summary
D)denormalized

Accepted Answer

The answer of Data warehouse contains ................ data that is...

Question 19

................... are responsible for running queries and reports against data warehouse tables.
A)hardware
B)software
C)end users
D)middle ware

Accepted Answer

The answer of ................... are responsible for running queries and...

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

Accepted Answer

The answer of The biggest drawback of the level indicator...

Quiz 3: Data Mining and Data Warehousing Frequently

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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