Google Cloud Professional Cloud Database Engineer — Question 151

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?

Answer options

• A. Use advanced DR by setting up a cascading read replica in the us-west1 region, and designate it as the failover DR replica. Test switchover by using the gcloud switchover command.
• B. Create a cross-region read replica, version 8.0.37, in the us-west1 region. Designate it as the failover DR replica, and test switchover by using the gcloud switchover command.
• C. Create a cross-region read replica version 8.0.34, in the us-west1 region. Designate it as the failover DR replica, and test switchover by using the gcloud switchover command.
• 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.

Correct answer: C

Explanation

The correct answer is C because it involves creating a cross-region read replica that matches the version of the production database, which ensures compatibility and zero data loss. Option A is incorrect because cascading read replicas are not necessary for simple DR setups. Option B is wrong due to the use of an incorrect version (8.0.37), and option D is incorrect as the command used is not appropriate for testing switchover in this scenario.