easyMultiple SelectObjective-mapped
CISA Practice Question: During a data migration from a legacy system to a…
Exhibit
Refer to the exhibit. [2024-06-15 14:23:45] ERROR: Constraint violation on table 'ORDERS' - foreign key 'CUST_ID' referencing 'CUSTOMERS.CUST_ID' - record with CUST_ID = 9999 not found in target. [2024-06-15 14:24:10] WARNING: Data type mismatch for column 'AMOUNT' in table 'ORDERS' - source decimal(10,2), target integer - truncation may occur. [2024-06-15 14:25:30] ERROR: Duplicate key value 'INV-1001' on table 'INVOICES' violates unique constraint. [2024-06-15 14:26:00] INFO: Rollback segment 'RBS1' is growing rapidly - check for long-running transactions.
During a data migration from a legacy system to a new ERP, the following log entries were generated. Which TWO issues should the IS auditor flag as high risk?
⚠ Common exam trap
Watch out — candidates often confuse operational issues (downtime, performance) with data integrity issues, or they underestimate the severity of referential integrity and duplicate key violations during migration.
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
✓
Constraint violation due to missing parent records
A constraint violation due to missing parent records indicates a referential integrity failure. In a data migration, this means child records are being inserted without their corresponding parent records, which can cause orphaned data and application logic errors. This is a high-risk issue as it compromises data consistency and may require complex reconciliation or rollback.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Source system downtime
Why it's wrong here
This issue is not observed in the provided log entries.
- ✗
Rapid growth of rollback segment
Why it's wrong here
This is a performance-related informational message, not a data integrity error.
- ✓
Constraint violation due to missing parent records
Why this is correct
This error indicates a foreign key violation where a parent record is missing, compromising referential integrity.
- ✓
Duplicate key violation
Why this is correct
This error violates a unique constraint, leading to data duplication and integrity issues.
- ✗
Data type mismatch between source and target
Why it's wrong here
This is a warning; while it may cause data truncation, it is less critical than actual errors.
Go deeper
Related to this question
About these practice questions
Courseiva writes every CISA question from scratch — 995 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.