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

…………………….. are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.
operational database
Well Done. Your Answer is Correct Keep it Up!
relational database
multidimensional database
None of the Option is Correct

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

The biggest drawback of the level indicator in the classic star schema is that is limits …………
quantify
Well Done. Your Answer is Correct Keep it Up!
flexibility
qualify
None of the Option is Correct

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

…………….. are responsible for running queries and reports against data warehouse tables.
middle ware
Well Done. Your Answer is Correct Keep it Up!
end users
software
None of the Option is Correct

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

The data from the operational environment enter …………………… of data warehouse.
current detail data
Well Done. Your Answer is Correct Keep it Up!
older detail data
lightly summarized data
None of the Option is Correct

A data warehouse is ……………

A data warehouse is ……………
updated by end users.
Well Done. Your Answer is Correct Keep it Up!
contains numerous naming conventions and formats
organized around important subject areas
None of the Option is Correct

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

Business Intelligence and data warehousing is used for …………..
data mining
Well Done. Your Answer is Correct Keep it Up!
forecasting
analysis of large volumes of product sales data
None of the Option is Correct

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

………………… supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting.
data mining
Well Done. Your Answer is Correct Keep it Up!
analytical processing
information processing
None of the Option is Correct

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

Data warehouse contains ……………. data that is never found in the operational environment.
normalized
Well Done. Your Answer is Correct Keep it Up!
informational
summary
None of the Option is Correct

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

The core of the multidimensional model is the ………………….. , which consists of a large set of facts and a number of dimensions.
dimensions cube
Well Done. Your Answer is Correct Keep it Up!
multidimensional cube
data cube
None of the Option is Correct

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

Data warehouse architecture is based on …………….
rdbms
Well Done. Your Answer is Correct Keep it Up!
dbms
sybase
None of the Option is Correct
Page 1 of 8
1 2 3 8