Which of the following controls will MOST effectively compensate for the lack of referential integrity?

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?
A . More frequent data backups
B . Periodic table link checks
C . Concurrent access controls
D . Performance monitoring tools

View Answer

Answer: B

Explanation:

Referential integrity is a property of data that ensures that all references between tables are valid and consistent. Disabling referential integrity controls can result in orphaned records, data anomalies, and inaccurate queries. 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. More frequent data backups, concurrent access controls, and performance monitoring tools do not address the issue of data consistency and accuracy.

References: ISACA CISA Review Manual 27th Edition, page 291