Free ISACA CISA Actual Exam Questions - Question 8 Discussion
management system (DBMS) software to provide users increased query performance. Which
of the following controls will MOST effectively compensate for the lack of referential
integrity?
B imo. Without built-in integrity checks, running regular table link audits is the only way to find and fix broken references before they cause bigger problems. Other options don’t really address relationship consistency.
B imo. Since referential integrity is about ensuring relationships between tables stay consistent, disabling those controls means the DBMS won’t automatically prevent or catch violations. Periodic table link checks are the only way to actively identify any broken references before they cause bigger problems. The others don’t directly address the missing integrity enforcement. Backups help recover after issues, but don’t prevent or detect them. Concurrent access controls focus on transaction handling, not relationship consistency. Performance tools just monitor speed, not data correctness.
B/C? Periodic checks (B) catch integrity issues, but without strict concurrency controls (C), users might create conflicts during updates. Both are important, but B seems more direct for referential integrity.
A/B? While backups won’t directly fix integrity, they can restore data to a consistent state after errors. But periodic checks (B) actively find broken links, so both help but B is more proactive.
B The system disables automatic referential integrity, so manual checks are the next best fallback. While the frequency of checks matters, some periodic validation is crucial to catch inconsistencies before they cause bigger problems. The other options don’t directly address broken links – backups (A) preserve data but don’t stop integrity issues, concurrency controls (C) handle simultaneous edits, and performance tools (D) monitor speed but not data correctness. So B fits best here as a compensating control.
B imo, since the DBMS no longer enforces the referential integrity automatically, running periodic checks is the best way to spot broken links or orphan records. More frequent backups (A) won’t prevent data inconsistencies—they just save the current state. Concurrent access controls (C) and performance monitoring (D) don’t really address data integrity directly. So B is the only one aimed at catching those violations after disabling the built-in controls.
Maybe B, periodic table link checks sound like a way to catch referential issues manually.