Answer-first summary for fast verification
Answer: Bring DB-1 back online.
To return to the pre-test configuration after promoting a read replica (DB-2) to primary during a business continuity test, the correct approach is to bring the original primary instance (DB-1) back online. Once DB-1 is online, you can then demote DB-2 back to a read replica. This restores the original setup with DB-1 as the primary instance and DB-2 and DB-3 as read replicas. Deleting DB-1 or DB-2, or creating a new read replica and promoting it to primary, would not restore the original configuration but instead create a new setup that does not match the pre-test state.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can you restore the original configuration of a Cloud SQL setup where DB-1 is the primary instance with cross-region read replicas DB-2 and DB-3, after promoting DB-2 during a business continuity test and now needing to revert back?
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.