Solved MCQ of Data Warehouse set-3

OLAP Cube illustration (Photo credit: Wikipedia)

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

A) DBMS

B) RDBMS

C) Sybase

D) SQL Server

2. .......................... 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

3. 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

4. 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

5. 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

6. 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

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

A) normalized

B) informational

C) summary

D) denormalized

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

A) Hardware

B) Software

C) End users

D) Middle ware

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

A) flexibility

B) quantify

C) qualify

D) ability

10. ............................. 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

Answers:

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

B) RDBMS

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

B) Analytical processing

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

C) Data cube

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

A) Current detail data

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

C) organized around important subject areas

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

D) All of the above

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

C) summary

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

C) End users

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

A) flexibility

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

C) Multidimensional database

Related posts

• MCQ on Data Mining with Answers set-1
• MCQ on Data Warehouse with Answers set-2
• Solved MCQ of Management Information System set-1
• MCQ of Management Information System With Answer set-2
• Solved MCQ of E-Commerce and E-Banking Set-1
• Solved MCQ of Data Structure Set-1
• Solved MCQ of System Analysis and Design Set-3
• Computer Organization and Architecture Interview Questions set-4

more »

MCQ on Data Warehouse with Answers set-2

Data Warehouse Overview (Photo credit: Wikipedia)

1. The full form of OLAP is


A) Online Analytical Processing

B) Online Advanced Processing

C) Online Advanced Preparation

D) Online Analytical Performance




2. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.

A) Data Mining

B) Data Warehousing

C) Document Mining

D) Text Mining




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

A) OLAP

B) OLTP

C) SMTP

D) FTP




4. 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





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

A) Star schema

B) Snowflake schema

C) Fact constellation

D) Star-snowflake schema




6. 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




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

A) many to many

B) one to one

C) one to many

D) many to one





8. 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




9. 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




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

A) Information processing

B) Analytical processing

C) Data mining

D) Transaction processing

Answers:

1. The full form of OLAP is

A) Online Analytical Processing


2. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.

B) Data Warehousing


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

B) OLTP


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

A) OLAP


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

C) Fact constellation


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

C) data source view


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

C) one to many


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

A) top-down view


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

D) Component Key


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

D) Transaction processing

Related Posts

• MCQ on Data Mining with Answers set-1
• Solved MCQ of Management Information System set-1
• MCQ of Management Information System With Answer set-2
• Solved MCQ of E-Commerce and E-Banking Set-1
• Solved MCQ of Data Structure Set-1
• Solved MCQ of System Analysis and Design Set-3
• Computer Organization and Architecture Interview Questions set-4

more »

MCQ on Data Mining with Answers set-1

1. ...................... is an essential process where intelligent methods are applied to extract data patterns.


A) Data warehousing

B) Data mining

C) Text mining

D) Data selection



2. Data mining can also applied to other forms such as ................


i) Data streams

ii) Sequence data

iii) Networked data

iv) Text data

v) Spatial data

A) i, ii, iii and v only

B) ii, iii, iv and v only

C) i, iii, iv and v only

D) All i, ii, iii, iv and v



3. Which of the following is not a data mining functionality?

A) Characterization and Discrimination

B) Classification and regression

C) Selection and interpretation

D) Clustering and Analysis



4. ............................. is a summarization of the general characteristics or features of a target class of data.

A) Data Characterization

B) Data Classification

C) Data discrimination

D) Data selection





5. ............................. is a comparison of the general features of the target class data objects against the general features of objects from one or multiple contrasting classes.

A) Data Characterization

B) Data Classification

C) Data discrimination

D) Data selection



6. Strategic value of data mining is ......................

A) cost-sensitive

B) work-sensitive

C) time-sensitive

D) technical-sensitive



7. ............................. 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



8. The various aspects of data mining methodologies is/are ...................

i) Mining various and new kinds of knowledge

ii) Mining knowledge in multidimensional space

iii) Pattern evaluation and pattern or constraint-guided mining.

iv) Handling uncertainty, noise, or incompleteness of data


A) i, ii and iv only

B) ii, iii and iv only

C) i, ii and iii only

D) All i, ii, iii and iv



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

A) Knowledge Database

B) Knowledge Discovery Database

C) Knowledge Data House

D) Knowledge Data Definition



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

A) Data

B) Information

C) Query

D) Useful information

Answers:

1. ...................... is an essential process where intelligent methods are applied to extract data patterns.

B) Data mining

2. Data mining can also applied to other forms such as ................

i) Data streams

ii) Sequence data

iii) Networked data

iv) Text data

v) Spatial data

D) All i, ii, iii, iv and v

3. Which of the following is not a data mining functionality?

C) Selection and interpretation


4. ............................. is a summarization of the general characteristics or features of a target class of data.

A) Data Characterization


5. ............................. is a comparison of the general features of the target class data objects against the general features of objects from one or multiple contrasting classes.

C) Data discrimination


6. Strategic value of data mining is ......................

C) time-sensitive


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

B) Data Classification


8. The various aspects of data mining methodologies is/are ...................

i) Mining various and new kinds of knowledge

ii) Mining knowledge in multidimensional space

iii) Pattern evaluation and pattern or constraint-guided mining.

iv) Handling uncertainty, noise, or incompleteness of data

D) All i, ii, iii and iv


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

B) Knowledge Discovery Database


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

D) Useful information

Related Posts

• Solved MCQ of Management Information System set-1
• MCQ of Management Information System With Answer set-2
• Solved MCQ of E-Commerce and E-Banking Set-1
• Solved MCQ of Data Structure Set-1
• Solved MCQ of System Analysis and Design Set-3
• Computer Organization and Architecture Interview Questions set-4

more »