When Should Data Cleansing Be Performed in Data Conversion?
Short answer
B Data cleansing must be completed prior to transformation to ensure accurate field mapping and prevent error propagation in converted datasets.
Question
Key Takeaways
Tests the optimal sequencing of data conversion steps, with the trap being confusion between extraction, transformation, and loading phases.
Data cleansing ensures data quality before processing in conversion workflows. This page establishes why cleansing must occur prior to transformation to prevent error propagation.
Common mistake: Load (A) is frequently chosen, but transforming uncleaned data introduces formatting errors that compromise the final database state.
Expert Analysis
Why the Answer Is Correct
Data conversion follows a standardized lifecycle where raw information is pulled, refined, formatted, and finally stored. Cleansing must occur prior to transformation because applying mapping rules or calculations to dirty data produces compounding errors. By removing duplicates, correcting formats, and resolving inconsistencies first, auditors ensure that downstream processing operates on reliable records.
Why the Other Options Are Wrong
Extraction (D) is the initial step that retrieves raw files, making it impossible to cleanse data that has not yet been retrieved. Validation (C) typically runs concurrently with cleansing or immediately follows extraction to flag rule violations rather than actively repairing them. Loading (A) occurs at the end of the pipeline, meaning transformation would have already processed uncleaned records if cleansing were delayed until after loading.
Community Comment Notes
Several candidates like Swallows correctly emphasize that cleansing optimizes quality before mapping changes occur. As Swallows noted, 'optimize the quality and reliability' before processing. Others like topikal suggest extraction first, which is logically required since raw files must exist before cleaning. Debates around loading often overlook that transformation inherently bridges cleansing and final storage.
Exam Strategy
Memorize the ETL sequence and understand that data integrity dictates ordering. Always prioritize quality assurance steps like cleansing before any structural changes or final imports occur.
Frequently Asked Questions
Why is cleansing not performed before extraction?
Can validation replace data cleansing in conversion?
Community Votes
60% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 3 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 3
-
Swallows 👍 3 Answered BB. transformation is the correct answer. Data cleansing should be completed before data transformation to optimize the quality and reliability of the converted data.
-
topikal 👍 1 Answered DD is the answer, Data cleansing is best before extraction
-
shalota2 👍 1 Answered ACould be A
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.
Related Analysis
Practice All CISA Questions
Access 400 questions with complete answers and detailed explanations.
View Full CISA Practice Test →