Managing Implementation and Ensuring Solution and Operations Reliability →mediumMultiple SelectObjective-mapped
Google PCA Practice Question: Managing Implementation and Ensuring Solution and Operations Reliability
A company is designing a disaster recovery plan for their Cloud SQL for PostgreSQL database. They need to ensure that they can recover from a regional outage with minimal data loss. Which TWO strategies should they implement? (Choose two.)
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
✓
Create a cross-region read replica
Cross-region replication (using a read replica in another region) and automated backups with PITR provide regional DR. A failover replica in the same region does not protect against region failure. On-premises backup is not mentioned. Import/export is for migration, not DR.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Export the database daily to Cloud Storage
Why it's wrong here
Export is a manual process and may not provide minimal data loss.
- ✗
Configure a failover replica in the same region
Why it's wrong here
Same region does not protect against regional outage.
- ✗
Use a Cloud SQL for PostgreSQL on-premises backup
Why it's wrong here
Not a Cloud SQL feature.
- ✓
Create a cross-region read replica
Why this is correct
A cross-region read replica can be promoted to primary in a disaster, minimizing data loss.
- ✓
Enable automated backups and point-in-time recovery
Why this is correct
Backups and PITR allow restoring to a point in time in a different region if the backup is stored in a multi-region location.
Go deeper
Related to this question
Learn chapter
Introduction to Google Cloud Platform
Key term
Cloud SQL
Cloud SQL is a fully managed relational database service that lets you set up, maintain, and scale SQL databases (like MySQL, PostgreSQL, and SQL Server) in the cloud without managing the underlying infrastructure.
Key term
Regional
Regional refers to a deployment strategy where cloud resources are distributed across multiple geographic areas to improve availability, reduce latency, and meet compliance requirements.
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.