10 Questions
What is the general guideline for the number of records to be updated when considering a full refresh of the data warehouse?
Between 15% and 25% of the total number of records
When should a full refresh of the data warehouse be seriously considered?
When more than 25% of the source records change daily
Who is responsible for ensuring that the data in the source systems conforms to the business rules?
Data Integrity Specialist
Who establishes the acceptable levels of data quality?
Data Consumer
What is the primary role of the Data Expert?
Identifying pollution in the source systems
Who is ultimately responsible for resolving data corruption as data is transformed and moved into the data warehouse?
Data Policy Administrator
What is the primary role of the Data Correction Authority?
Applying data cleansing techniques
Who is responsible for the quality of data input into the source systems?
Data Producer
What is the role of the Data Consistency Expert?
Ensuring data consistency
When is a full refresh of the data warehouse usually done?
When a major restructuring or similar mass changes take place
Test your understanding of the ETL process, from data extraction to data loading, and its challenges. Learn about the robust enterprise-grade ETL applications and the nature of source systems that make ETL functions difficult. Evaluate your knowledge of data warehouse and transaction processing concepts.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free