Answer-first summary for fast verification
Answer: Create two new read replicas from the new primary instance, one in Region3 and one in a new region.
The best option is C. By creating two new read replicas from the new primary instance (the promoted read replica in Region2), one in Region3 and one in a new region, you ensure that you maintain the same level of capacity and data redundancy. This approach restores the database capacity and maintains high availability and disaster recovery capabilities by distributing the read replicas across multiple regions. Creating new replicas from the promoted primary is also likely faster than other options and ensures redundancy if another regional event occurs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You manage a Cloud SQL for PostgreSQL instance located in Region1, which has two read replicas: one in Region2 and another in Region3. An unforeseen event in Region1 necessitates a disaster recovery procedure that involves promoting the read replica in Region2. To guarantee that your application maintains the same database capacity during this transition, what steps should you take to ensure continuity before you reroute the connections?
A
Enable zonal high availability on the primary instance. Create a new read replica in a new region.
B
Create a cascading read replica from the existing read replica in Region3.
C
Create two new read replicas from the new primary instance, one in Region3 and one in a new region.
D
Create a new read replica in Region1, promote the new read replica to be the primary instance, and enable zonal high availability.