IS 管理者は最近、ユーザーにクエリ パフォーマンスの向上を提供するために、データベース管理システム (DBMS) ソフトウェアの特定の参照整合性コントロールを無効にしました。次のコントロールのうち、参照整合性の欠如を最も効果的に補うのはどれですか。
正解:B
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: ISACACISA Review Manual 27th Edition, page 291