Certified Information Systems Auditor (CISA) — Question 1014

During data conversion, data cleansing is BEST performed prior to:

Answer options

• A. load
• B. transformation
• C. validation
• D. extraction

Correct answer: B

Explanation

Data cleansing should ideally occur before transformation because this ensures that the data being transformed is accurate and consistent. Performing cleansing after transformation can lead to errors being propagated into the final datasets. The other options, load, validation, and extraction, are not the optimal times for cleansing as they either follow the transformation step or focus on different aspects of the data process.