Question

92) Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:

A) data auditing.
B) defragmentation.
C) data scrubbing.
D) data optimization.
E) data normalization.

Answer 1

C) Data scrubbing is the process of detecting and correcting errors, inconsistencies and redundancies in a database or file. It involves validating and verifying data, checking for completeness and accuracy, and fixing formatting issues. Data scrubbing is important for maintaining data quality and ensuring that data is reliable, consistent and up-to-date. It can also improve the performance of databases and applications by reducing the amount of unnecessary data stored. Data scrubbing is often an automated process that can be scheduled to run periodically to ensure ongoing data quality.