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?

Exam-Like

Enable zonal high availability on the primary instance. Create a new read replica in a new region.

21.4%

Create a cascading read replica from the existing read replica in Region3.

15.7%

Create two new read replicas from the new primary instance, one in Region3 and one in a new region.

45.7%

Create a new read replica in Region1, promote the new read replica to be the primary instance, and enable zonal high availability.

17.1%

Google Professional Data Engineer