Question 110
A database team repairs this problem: A Cloud SQL recovery team discovers that the only standby replica is unreachable during a total region outage. Which measured outcome validates the correction?
Explanation
Correct Answer
A full-region tabletop validates write service in the alternate region without using the failed primary. This is the intended effect of: Prepare and rehearse supported cross-region promotion or recovery with application endpoint changes. The original defect was the runbook lacks an alternate-region writable promotion or restoration path.
Incorrect Answers
This finding relates to a situation in which a mobile app needs synchronized document-oriented user profiles with flexible fields and client SDK integration. The current remediation must instead show that a full-region tabletop validates write service in the alternate region without using the failed primary.
That result would matter when a regulated database backup policy requires recovery copies outside a primary failure boundary, but all copies remain colocated. It does not establish that a full-region tabletop validates write service in the alternate region without using the failed primary, which is the evidence needed here.
The result would be meaningful for a problem where an AlloyDB database has read pools in one region but the business incorrectly calls them a cross-region disaster recovery setup. For this question, closure depends on confirming that a full-region tabletop validates write service in the alternate region without using the failed primary.