ExamGecko
Question list
Search
Search

Related questions

Question 44 - CISA discussion

Report
Export

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
Answers
A.
More frequent data backups
B.
Periodic table link checks
Answers
B.
Periodic table link checks
C.
Concurrent access controls
Answers
C.
Concurrent access controls
D.
Performance monitoring tools
Answers
D.
Performance monitoring tools
Suggested 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.Reference:ISACA CISA Review Manual 27th Edition, page 291

asked 18/09/2024
ERIK BURDETT
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first