Multiple choice technology databases

Data scrubbing is which of the following?

  1. A process to reject data from the data warehouse and to create the necessary indexes

  2. A process to load the data in the data warehouse and to create the necessary indexes

  3. A process to upgrade the quality of data after it is moved into a data warehouse

  4. A process to upgrade the quality of data before it is moved into a data warehouse
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data scrubbing is the process of cleaning and improving data quality BEFORE it is loaded into the data warehouse. It involves correcting errors, standardizing formats, and resolving inconsistencies during the ETL process. Scrubbing happens as part of the transformation phase, not after loading.

Keep practicing — related questions