Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 152

Question

You are a DBA at a retail company. The production databases are running in Cloud SQL for MySQL Enterprise Plus edition, version 8.0.34, in the us-centrall region. You need to set up and test disaster recovery (DR) with zero data loss in the us-west1 region. What should you do?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Create a cross-region read replica, version 8.0.34, in the us-west1 region. Test switchover by using the gcloud promote-replica with failover command. By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 152