MCQ Questions On Data Warehouse Set-3

This set of MCQ questions on data warehouse includes collections of multiple choice questions on fundamental of data warehouse techniques. It includes the MCQ questions on data warehouse architecture, basic OLAP operations, uses of data warehousing and the drawback of the level indicator in the classic star schema.

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

Please follow and like us: