Data Warehousing MCQs

30 questionsDatabasePage 3 of 4

Practice free Data Warehousing multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 30 questions — no login required.

Question 19medium
Most operational systems are based on the use of transient data.
⚑ Report✎ Feedback
Question 20hard
Independent data marts are often created because an organization focuses on a series of short-term business objectives.
⚑ Report✎ Feedback
Question 21easy
Joining is the process of partitioning data according to predefined criteria.
⚑ Report✎ Feedback
Advertisement
Question 22hard
The role of the ETL process is to identify erroneous data and to fix them.
⚑ Report✎ Feedback
Question 23medium
Data in the data warehouse are loaded and refreshed from operational systems.
⚑ Report✎ Feedback
Question 24hard
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
⚑ Report✎ Feedback
Advertisement
Question 25medium
Periodic data are data that are physically altered once added to the store.
⚑ Report✎ Feedback
Question 26medium
Both status data and event data can be stored in a database.
⚑ Report✎ Feedback
Question 27medium
Static extract is used for ongoing warehouse maintenance.
⚑ Report✎ Feedback
1234