Data Cleansing purpose

• A. Encrypting data
• B. Archiving data
• C. Sorting data
• D. Identifying inaccurate or irrelevant data and modifying or deleting as appropriate

Answer: (D)

Data cleansing focuses on improving the quality of data by identifying inaccurate or irrelevant information and modifying or removing it as appropriate. In practice, this means detecting duplicates, correcting errors, handling missing values, standardizing formats, and removing data that doesn’t meet business rules. The result is data that is accurate, complete, and consistent, which is essential for reliable analysis and decision making. Encrypting data protects confidentiality, archiving preserves historical records, and sorting merely orders data; none of these directly address data quality issues.