Exam Professional Cloud Database Engineer topic 1 question 153 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 153
Topic #: 1

[All Professional Cloud Database Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by Sai_Vignesh at Aug. 7, 2025, 3:18 a.m.

Comments

Submit Cancel

Sai_Vignesh

1 week, 1 day ago

Selected Answer: C

Ruled out the other options because they don't meet the primary requirement. That leaves C.

upvoted 1 times

...