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?
Click on the arrows to vote for the correct answer
A. B. C. D.C.
Referential integrity controls in a database management system (DBMS) are essential for ensuring that relationships between tables are maintained, and that data entered into the system is accurate and consistent. Disabling these controls can result in significant data quality issues, including data inconsistencies, data corruption, and data loss.
To compensate for the lack of referential integrity controls, it is necessary to implement other compensating controls.
Option A: Performance monitoring tools
Performance monitoring tools are used to monitor the performance of the DBMS and identify areas where improvements can be made. While these tools can help identify performance issues related to the lack of referential integrity controls, they do not compensate for the lack of data integrity.
Option B: More frequent data backups
More frequent data backups are important for ensuring that data can be restored in the event of a system failure or data loss. However, backups do not compensate for the lack of referential integrity controls.
Option C: Periodic table link checks
Periodic table link checks involve verifying the relationships between tables in the database and ensuring that the data in each table is consistent with the data in related tables. This compensating control can help mitigate the risk of data inconsistencies resulting from the lack of referential integrity controls. However, it may not be as effective as implementing referential integrity controls.
Option D: Concurrent access controls
Concurrent access controls restrict access to the database to prevent multiple users from modifying the same data simultaneously. While this control can help prevent some data inconsistencies, it does not compensate for the lack of referential integrity controls.
Based on the above analysis, option C, periodic table link checks, is the most effective compensating control for the lack of referential integrity controls in the DBMS. However, it is important to note that periodic checks may not be as effective as having referential integrity controls in place, and should only be used as a temporary solution until referential integrity controls can be reinstated.