DATA WAREHOUSING QUIZ

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

All of these

One-to-many

One-to-one

Many-to-many

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

At least one data mart

Data that can extracted from numerous internal and external sources

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Data in the data warehouse are loaded and refreshed from operational systems.

True

False

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 : ?

A goal of data mining includes which of the following?

To confirm that data exists

To create a new data warehouse

To analyze data for expected relationships

To explain some observed event or condition

TRUE ANSWER : ?
YOUR ANSWER : ?

Independent data marts are often created because an organization focuses on a series of short-term business objectives.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The generic two-level 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 : ?

Fact tables are which of the following?

Partially normalized

Partially denoralized

Completely normalized

Completely denoralized

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 : ?

↑