mediumMultiple ChoiceObjective-mapped
CISA Practice Question: During the implementation of a new ERP system,…
During the implementation of a new ERP system, the project team discovers that the legacy system data cannot be directly migrated due to incompatible data formats. The project manager proposes building a custom script to extract, transform, and load (ETL) data. Which of the following is the BEST course of action?
⚠ Common exam trap
Test-takers frequently assume custom scripts are inherently risky and choose to delay or abandon data, failing to recognize that with proper testing and validation, custom ETL is a standard and effective solution for incompatible data formats.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Proceed with the custom ETL script after thorough testing and validation.
Building a custom ETL script is a common and acceptable approach when legacy data formats are incompatible with a new ERP system. The key is that the script must undergo thorough testing and validation to ensure data integrity, completeness, and accuracy before migration. This balances the need for timely implementation with the risk of data corruption, which can be mitigated through rigorous quality assurance processes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Manually re-enter all legacy data into the new system.
Why it's wrong here
Manual re-entry is inefficient and error-prone.
- ✗
Delay the implementation until a commercial migration tool is available.
Why it's wrong here
Unnecessary delay; alternatives exist.
- ✓
Proceed with the custom ETL script after thorough testing and validation.
Why this is correct
Custom ETL is appropriate with proper validation.
- ✗
Abandon the legacy data and start fresh in the new system.
Why it's wrong here
Loss of historical data is not advisable.
Go deeper
Related to this question
About these practice questions
This CISA question is part of Courseiva's 995-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This CISA practice question is part of Courseiva's free ISACA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the CISA exam.