Manage a solution that can span multiple database technologies →mediumMultiple SelectObjective-mapped
PCDE Practice Question: Manage a solution that can span multiple database technologies
A Cloud SQL for MySQL instance is being used for a production application. The team wants to implement a disaster recovery plan that can recover from a regional outage with minimal data loss and automatic failover. Which three steps should they take? (Choose THREE.)
⚠ Common exam trap
Candidates often confuse read replicas in the same region as providing disaster recovery for regional outages, but they only offer read scaling and high availability within the same region, not cross-region failover.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Enable automated backups with a suitable retention period.
Automated backups in Cloud SQL for MySQL provide a baseline for disaster recovery by creating daily backups that can be restored to a new instance. With a suitable retention period, you can recover from data corruption or accidental deletion, though backups alone do not provide automatic failover or minimal data loss during a regional outage.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Enable automated backups with a suitable retention period.
Why this is correct
Backups are essential for recovery.
- ✗
Create a read replica in the same region.
Why it's wrong here
Does not survive a regional outage.
- ✗
Increase the storage size to accommodate future growth.
Why it's wrong here
Not a DR measure.
- ✓
Create a cross-region read replica and configure it for failover.
Why this is correct
Cross-region replica provides DR and can be promoted.
- ✓
Enable binary logging (log_bin) for point-in-time recovery.
Why this is correct
PITR reduces data loss.
Go deeper
Related to this question
About these practice questions
One of 1,446 original PCDE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PCDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PCDE exam.