Google Cloud Professional Cloud Database Engineer — Question 71

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?

Answer options

• A. Bring DB-1 back online.
• B. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
• C. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
• D. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Correct answer: D

Explanation

The correct answer is D because creating a new read replica (DB-4) in the same region as DB-1 and promoting it ensures that DB-1 can be restored to its original state without losing data or configuration. Option A is incorrect since bringing DB-1 back online does not address the replica promotion. Option B involves unnecessary deletion and recreation. Option C would not work because deleting DB-2 does not guarantee that DB-1 would revert to primary without a proper setup.