Question 1,192 of 1,446
Deploy scalable and highly available databases in Google Cloud →mediumMultiple ChoiceObjective-mapped
PCDE Practice Question: Deploy scalable and highly available databases in Google Cloud
A DevOps engineer wants to test disaster recovery for a Cloud SQL for MySQL instance by simulating a zone failure without impacting production traffic. They need to ensure minimal data loss. Which approach should they take?
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
✓
Promote a cross-region read replica in a test project to validate the failover process
Non-destructive tests are best done using read replicas. Promoting a read replica in a test environment avoids impacting production. Restoring a backup from Cloud Storage would not test the failover process. Using HA failover would affect production. Restoring to a new instance from PITR tests recovery but not failover.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Take an on-demand backup and restore it to a new Cloud SQL instance
Why it's wrong here
Restoring a backup tests recovery but not the failover process, and it does not simulate zone failure.
- ✗
Use the gcloud command to perform a point-in-time recovery on the same instance
Why it's wrong here
PITR is for recovery to a past point in time, not for testing failover scenarios.
- ✗
Enable the HA configuration and trigger a failover by stopping the primary instance
Why it's wrong here
Triggering HA failover in production would cause downtime and is destructive; not suitable for testing.
- ✓
Promote a cross-region read replica in a test project to validate the failover process
Why this is correct
Using a read replica in a test project is non-destructive and simulates the failover process without affecting production.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jul 4, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.