SQL FOR DATABASE CONSTRUCTION QUIZ

OLAP uses measures, dimensions and associations.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Report types include static, dynamic, query and OLAP.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

Dirty data

Inconsistent data

Non-integrated data

Too much data

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

Data metadata

Data extraction/cleaning/preparation programs

Data warehouse data

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) reporting systems cannot do which of the following operations?

Group data

Both filter and group data

Modify data

Filter data

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) systems do not obtain data from operational databases.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) reporting analyses can be performed using ________ .

both standard SQL and extensions to SQL

OLAP only

extensions to SQL only

standard SQL only

TRUE ANSWER : ?
YOUR ANSWER : ?

Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑