Data Warehousing - Study Mode

[#26] Both status data and event data can be stored in a database.
Correct Answer

(A) True

[#27] Static extract is used for ongoing warehouse maintenance.
Correct Answer

(B) False

[#28] Every key used to join the fact table with a dimensional table should be a surrogate key.
Correct Answer

(A) True

[#29] Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Correct Answer

(B) False

[#30] Data scrubbing can help upgrade data quality

it is not a long-term solution to the data quality problem.
Correct Answer

(A) True