Question 218
You have a Cloud SQL for PostgreSQL instance in Region’ with one read replica in Region2 and another read replica in Region3. An unexpected event in Region’ requires that you perform disaster recovery by promoting a read replica in Region2. You need to ensure that your application has the same database capacity available before you switch over the connections. What should you do?
- 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.