A star schema has what type of relationship between a dimension and fa – 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

An enormous collection of data on various topics from a variety of internal and external sources, compiled by a firm for its own use or for use by its clients, is called :
An Enterprise Resource Planning application is an example of a(n) ______.
_________ is an intermediate storage area used for data processing during the extract, transform and load process of data warehousing .
Most NoSQL databases support automatic _____ meaning that you get high availability and disaster recovery.
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Static extract is used for ongoing warehouse maintenance.
Every key used to join the fact table with a dimensional table should be a surrogate key.
Periodic data are data that are physically altered once added to the store.
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.