Joining is the process of partitioning data according to predefined criteria.
Select an option to see the answer and solution.
Database · all questionsData Warehousing
Data Warehousing
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
30
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
The role of the ETL process is to identify erroneous data and to fix them.
Select an option to see the answer and solution.
Data in the data warehouse are loaded and refreshed from operational systems.
Select an option to see the answer and solution.
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Select an option to see the answer and solution.
Periodic data are data that are physically altered once added to the store.
Select an option to see the answer and solution.
Both status data and event data can be stored in a database.
Select an option to see the answer and solution.
Static extract is used for ongoing warehouse maintenance.
Select an option to see the answer and solution.
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
Select an option to see the answer and solution.
Every key used to join the fact table with a dimensional table should be a surrogate key.
Select an option to see the answer and solution.
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Select an option to see the answer and solution.