Every key used to join the fact table with a dimensional table should – McqOptions

MCQOPTIONS

1.	Every key used to join the fact table with a dimensional table should be a surrogate key.%!
A.	True
B.	False
Answer» B. False

Discussion

No Comment Found

Related MCQs

Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.%!
Periodic data are data that are physically altered once added to the store.%!
Independent data marts are often created because an organization focuses on a series of short-term business objectives.%!
Every key used to join the fact table with a dimensional table should be a surrogate key.%!
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.%!
Most operational systems are based on the use of transient data.%!
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.%!
Data in the data warehouse are loaded and refreshed from operational systems.%!
Data in operational systems are typically fragmented and inconsistent.%!
Static extract is used for ongoing warehouse maintenance.%!