Question 140
A database team wants to prevent a recurrence of this issue: An AlloyDB failover test reports success because the console shows a new primary, while users cannot complete transactions. Which preventive practice is most relevant?
Explanation
Correct Answer
Make application-level acceptance mandatory for AlloyDB HA testing. The original failure arose from: Infrastructure role transition was not checked against application connection and transaction recovery. The control reduces that failure mode.
Incorrect Answers
For the situation in which a Cloud SQL service promises recovery to within five minutes, but backups are only taken nightly, it makes sense to map backup frequency, log retention, and PITR capability to each application's RPO. Here, infrastructure role transition was not checked against application connection and transaction recovery, so the safeguard misses the recurring fault.
Here, infrastructure role transition was not checked against application connection and transaction recovery. The option concerns the separate risk of a situation in which a Cloud SQL read replica increasingly falls minutes behind after a bulk-import job starts.
For the situation in which a document application requiring geographic resilience is deployed to a database location that meets only one region's risk model, it makes sense to record geographic availability and residency decisions before creating databases. Here, infrastructure role transition was not checked against application connection and transaction recovery, so the safeguard misses the recurring fault.