GoogleGoogle
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #68
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #68: Real Exam Question with Answer & Explanation
The correct answer is D: Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.. https://cloud.google.com/sql/docs/mysql/high-availability#failback
Implementing High Availability and Disaster Recovery
Question
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?
Options
- ABring DB-1 back online.
- BDelete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
- CDelete DB-2 so that DB-1 automatically reverts to the primary instance.
- DCreate DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
Explanation
https://cloud.google.com/sql/docs/mysql/high-availability#failback
Topics
#Cloud SQL#Read Replicas#Failover#Disaster Recovery
Community Discussion
No community discussion yet for this question.