Data Warehousing - Practice Questions

Question 1

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

Accepted Answer

Question 2

An operational system is which of the following?

Accepted Answer

Question 3

Data scrubbing is which of the following?

Accepted Answer

Question 4

A multifield transformation does which of the following?

Accepted Answer

Question 5

The load and index is which of the following?

Accepted Answer

Question 6

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

Accepted Answer

Question 7

The generic two-level data warehouse architecture includes which of the following?

Accepted Answer

Question 8

Transient data is which of the following?

Accepted Answer

Question 9

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

Accepted Answer

Question 10

A data warehouse is which of the following?

Accepted Answer