DATA WAREHOUSING QUIZ

Static extract is used for ongoing warehouse maintenance.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Fact

Dimension

Helper

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Data in operational systems are typically fragmented and inconsistent.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Data transformation includes which of the following?

Joining data from one source into various sources of data

A process to change data from a summary level to a detailed level

Separating data from one source into various sources of data

A process to change data from a detailed level to a summary level

TRUE ANSWER : ?
YOUR ANSWER : ?

Fact tables are which of the following?

Partially denoralized

Completely normalized

Partially normalized

Completely denoralized

TRUE ANSWER : ?
YOUR ANSWER : ?

A data warehouse is which of the following?

Contains numerous naming conventions and formats.

Can be updated by end users.

Contains only current data.

Organized around important subject areas.

TRUE ANSWER : ?
YOUR ANSWER : ?

A star schema has what type of relationship between a dimension and fact table?

All of these

One-to-many

Many-to-many

One-to-one

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?