Google PCA Manage implementation of cloud architecture Practice Question
A company is designing a disaster recovery plan for their Cloud SQL for PostgreSQL instance. They want to ensure that the database can be recovered in another region within minutes with minimal data loss. Which three actions should they take? (Choose three.)
⚠ Common exam trap
It's easy for candidates to confuse zonal high availability (a failover replica in a different zone) with cross-region disaster recovery, mistakenly thinking a zonal replica satisfies the 'another region' requirement.
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 point-in-time recovery
Enabling point-in-time recovery (PITR) for Cloud SQL for PostgreSQL is correct because it allows you to restore the database to any specific point in time within the backup retention period, minimizing data loss to within seconds. PITR relies on write-ahead logs (WAL) archived continuously, which are essential for recovering to a precise timestamp in a disaster scenario. This directly supports the requirement of minimal data loss during cross-region recovery.
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 point-in-time recovery
Why this is correct
Allows recovery to a specific point in time, minimizing data loss.
- ✓
Regularly test the failover procedure
Why this is correct
Ensures the DR plan works when needed.
- ✗
Configure a failover replica in a different zone within the same region
Why it's wrong here
Only protects against zone failure, not regional disaster.
- ✓
Enable cross-region replication using Cloud SQL's replica feature
Why this is correct
Provides a readable replica in another region for failover.
- ✗
Enable automated backups with a retention period of 30 days
Why it's wrong here
Backups are for within-region, not for quick cross-region recovery.
Go deeper
Related to this question
Learn chapter
Introduction to Google Cloud Platform
Key term
Disaster recovery
Disaster recovery is a set of policies, procedures, and tools that help an organization restore critical IT systems and data after a disruptive event.
Key term
CAN
A CAN (Controller Area Network) is a robust vehicle bus standard designed to allow microcontrollers and devices to communicate with each other without a host computer.
About these practice questions
Courseiva writes every PCA question from scratch — 955 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PCA 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 PCA exam.