CRISC · Question #7
it was determined that replication of a critical database used by two business units failed. Which of the following should be of GREATEST concern1?
The correct answer is C. The lack of integrity of data. The failure of critical database replication should primarily raise concerns about the integrity of data, as the replica may no longer accurately reflect the primary source.
Question
it was determined that replication of a critical database used by two business units failed. Which of the following should be of GREATEST concern1?
Options
- AThe underutilization of the replicated Iink
- BThe cost of recovering the data
- CThe lack of integrity of data
- DThe loss of data confidentiality
How the community answered
(29 responses)- A7% (2)
- B21% (6)
- C62% (18)
- D10% (3)
Why each option
The failure of critical database replication should primarily raise concerns about the integrity of data, as the replica may no longer accurately reflect the primary source.
Underutilization of a replicated link is an efficiency issue, not a critical data failure concern directly related to replication failure.
The cost of recovering data is a consequence, but the immediate and most critical concern stems from the compromised state of the data itself that necessitates the recovery.
When critical database replication fails, the greatest concern is the potential for data inconsistency or corruption between the primary and replica databases. This compromises data integrity, meaning the standby data may be inaccurate or unreliable if a failover becomes necessary, leading to severe operational issues.
Loss of data confidentiality involves unauthorized access or disclosure, which is not directly caused or implied by a failure in database replication; replication failures primarily impact availability and integrity.
Concept tested: Database replication failure impact
Source: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.