Certified Information Systems Auditor (CISA) — Question 522

IS management has recently disabled certain referential integrity controls in the database 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?

Answer options

• A. More frequent data backups
• B. Periodic table link checks
• C. Performance monitoring tools
• D. Concurrent access controls

Correct answer: B

Explanation

Periodic table link checks are essential in identifying and correcting broken links between tables that could occur due to the lack of referential integrity. While more frequent data backups (A) can help recover lost data, they do not address the integrity issues directly. Performance monitoring tools (C) focus on system efficiency, and concurrent access controls (D) manage simultaneous data access, neither of which compensate for missing referential integrity.