Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
ISACA Certified Information Systems Auditor · Isaca
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
The most effective way to compensate for the lack of referential integrity is to perform periodic table link checks, which verify that all foreign keys match existing primary keys in the related tables.
The periodic table link checks (option B) would be more effective in compensating for the disabled referential integrity controls. While it doesn't provide real-time enforcement like referential integrity, periodic checks can help identify and rectify data integrity issues, albeit not as promptly. Therefore, option B would be the most suitable compensatory control in this scenario.
B. Periodic table link checks