ISACA Certified Information Systems Auditor (CISA) ExamDomain 4: Information Systems Operations and Business ResilienceMedium
An organization is migrating its primary database to a new cloud platform. The IS auditor is tasked with evaluating the data migration process. Which of the following is the MOST important control to ensure data integrity during and after the migration?
- AImplementing robust access controls for the migration team members.
- BEnsuring the new cloud platform meets all security compliance standards.
- CPerforming reconciliation checks between source and target data after migration.
- DConducting performance testing of the database on the new platform.
Show answer & explanationAnswer & explanation
Correct answer: C. Performing reconciliation checks between source and target data after migration.
Reconciliation checks directly verify that all data has been accurately and completely transferred from the source to the target system without corruption or loss, which is fundamental to ensuring data integrity.
Why the other options are wrong
- A. Access controls are crucial for security but do not directly confirm the integrity of the data itself post-migration.
- B. Security compliance is important for the platform itself, but doesn't directly verify data integrity during migration.
- D. Performance testing verifies the system's speed and efficiency, not the integrity of the data content.
Data Reconciliation
The process of comparing two or more sets of data to ensure consistency and accuracy, often used after data migration or system integration.
- Verifies completeness and correctness of data transfer.
- Detects discrepancies, errors, or omissions.
- Crucial for maintaining data integrity.
Memory trick: Reconciliation is like checking your bank statement; does it match?