Data Warehousing MCQs
Practice Data Warehousing MCQs for competitive exams.
Data Warehousing MCQs
Practice questions from this topic.
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Correct Answer: B
Every key used to join the fact table with a dimensional table should be a surrogate key.
Correct Answer: A
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
Correct Answer: A
Static extract is used for ongoing warehouse maintenance.
Correct Answer: B
Both status data and event data can be stored in a database.
Correct Answer: A
Periodic data are data that are physically altered once added to the store.
Correct Answer: B
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Correct Answer: B
Data in the data warehouse are loaded and refreshed from operational systems.
Correct Answer: A
The role of the ETL process is to identify erroneous data and to fix them.
Correct Answer: B
Joining is the process of partitioning data according to predefined criteria.
Correct Answer: B
Independent data marts are often created because an organization focuses on a series of short-term business objectives.
Correct Answer: A
Most operational systems are based on the use of transient data.
Correct Answer: A