DATA WAREHOUSING QUIZ

The role of the ETL process is to identify erroneous data and to fix them.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A snowflake schema is which of the following types of tables?

Dimension

Fact

Helper

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Periodic data are data that are physically altered once added to the store.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Data in operational systems are typically fragmented and inconsistent.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Both status data and event data can be stored in a database.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The @active data warehouse architecture includes which of the following?

Near real-time updates

Data that can extracted from numerous internal and external sources

All of these

At least one data mart

TRUE ANSWER : ?
YOUR ANSWER : ?

A data mart is designed to optimize the performance for well-defined and predicable uses.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The load and index is which of the following?

A process to reject data from the data warehouse and to create the necessary indexes

A process to upgrade the quality of data after it is moved into a data warehouse

A process to upgrade the quality of data before it is moved into a data warehouse

A process to load the data in the data warehouse and to create the necessary indexes

TRUE ANSWER : ?
YOUR ANSWER : ?

Most operational systems are based on the use of transient data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑