Google Cloud Professional Data Engineer — Question 144

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because creating two new read replicas from the new primary instance ensures that you have sufficient database capacity spread across different regions. Options A and D do not address the immediate need for capacity before switching over, and option B only adds a cascading replica without increasing capacity at the required locations.