The generic two-level data warehouse architecture includes which of th – McqOptions

MCQOPTIONS

1.	The generic two-level data warehouse architecture includes which of the following??
A.	At least one data mart
B.	Data that can extracted from numerous internal and external sources
C.	Near real-time updates
D.	All of the above
Answer» C. Near real-time updates

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