_A star schema has what type of relationship between a dimension and f – McqOptions

MCQOPTIONS

1.	_A star schema has what type of relationship between a dimension and fact table?$?
A.	Many-to-many
B.	One-to-one
C.	One-to-many
D.	All of the above
Answer» D. All of the above

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.%!