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?
Periodic table link checks will be the most effective compensating control for the lack of referential integrity in the database management system. Referential integrity ensures that relationships between tables remain consistent, and periodic table link checks can help identify and correct any discrepancies or issues that arise from the disabled controls. More frequent data backups, performance monitoring tools, and concurrent access controls do not address the specific issue of maintaining data relationships and consistency.
B. Periodic table link checks
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.