Data scrubbing is
2018
Data scrubbing is
- A.
A process to reject data from the data warehouse and to create the necessary indexes.
- B.
A process to load the data in the data warehouse and to create the necessary indexes.
- C.
A process to upgrade the quality of data after it is moved into a data warehouse
- D.
A process to upgrade the quality of data before it is moved into a data warehouse
Attempted by 38 students.
Show answer & explanation
Correct answer: D
Definition: Data scrubbing is the process of improving the quality of data before it is moved into a data warehouse.
Common data scrubbing activities:
Remove duplicate records.
Correct or standardize inconsistent formats (dates, addresses, units).
Validate and correct incorrect or missing values.
Normalize categorical values (for example, unify 'NY' and 'New York').
Enforce business rules and referential integrity.
Why it matters: clean data improves analytics accuracy, reduces errors, and can lower storage and processing costs.
Note: Some modern pipelines perform cleaning after loading (ELT), but the term data scrubbing most commonly refers to cleaning performed before loading as part of ETL.
A video solution is available for this question — log in and enroll to watch it.