Consider the following two statements : (A) Data scrubling is a process to…
2016
Consider the following two statements :
(A) Data scrubling is a process to upgrade the quality of data, before it is moved into Data warehouse.
(B) Data scrubling is a process of rejecting data from data warehouse to create indexes.
Which one of the following options is correct ?
- A.
(A) is true, (B) is false.
- B.
(A) is false, (B) is true.
- C.
Both (A) and (B) are false.
- D.
Both (A) and (B) are true.
Attempted by 42 students.
Show answer & explanation
Correct answer: A
Correct answer: The statement that data scrubbing is a process to upgrade the quality of data before it is moved into a data warehouse is true; the statement that data scrubbing is a process of rejecting data from the data warehouse to create indexes is false.
Why the first statement is true:
Data scrubbing (data cleansing) involves detecting and correcting or removing inaccurate, incomplete, duplicate, or inconsistent records.
This process is typically performed during ETL (extract, transform, load) so that the data loaded into the data warehouse is accurate and consistent.
Why the second statement is false:
Rejecting data from a data warehouse to create indexes is not a description of data scrubbing. Index creation is a separate database performance operation and does not involve rejecting data as part of cleansing.
Purging or archiving data (removing unwanted records) is different from scrubbing; scrubbing focuses on correcting or standardizing data rather than rejecting it to build indexes.