GCP Professional Cloud Architect Practice Question
An online retailer runs its primary PostgreSQL workload on a single-region Cloud SQL instance. The compliance team requires a disaster-recovery posture that guarantees a recovery point objective (RPO) of at most 5 minutes and a recovery time objective (RTO) under 1 hour if the region hosting the primary instance becomes unavailable. Operations wants the simplest managed approach that keeps additional cost low. Which solution best meets the business continuity requirements?
Create a cross-region Cloud SQL read replica in a second region and document a failover runbook that promotes it to primary during a regional outage.
Move PostgreSQL to self-managed Compute Engine VMs with regional persistent disks and replicate nightly snapshots to a different region using Storage Transfer Service.
Schedule automated Cloud SQL exports every 5 minutes to Cloud Storage and restore the latest export to a new instance in another region when needed.
Migrate the database to a multi-region configuration of Cloud Spanner to obtain automatic synchronous replication across regions.
Creating a cross-region read replica for the existing Cloud SQL instance keeps the database fully managed while streaming changes asynchronously to another region with typical replication lag in seconds, well within the 5-minute RPO. In a regional outage, administrators can promote the replica to primary and redirect application traffic, a process that is normally completed in minutes, satisfying the 1-hour RTO. The alternative options either rely on time-consuming backup restores, introduce significantly higher operational complexity, or require migrating to a more expensive service such as Cloud Spanner, so they do not fit the stated cost and simplicity constraints.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is RPO and RTO when discussing disaster recovery?
Open an interactive chat with Bash
How does a Cloud SQL read replica work for disaster recovery?
Open an interactive chat with Bash
What is Cloud Spanner, and why is it not suitable in this scenario?
Open an interactive chat with Bash
What is an RPO and an RTO in disaster recovery?
Open an interactive chat with Bash
How does Cloud SQL’s cross-region read replica ensure high availability?
Open an interactive chat with Bash
Why is migrating to Cloud Spanner not cost-efficient in this scenario?
Open an interactive chat with Bash
GCP Professional Cloud Architect
Designing and planning a cloud solution architecture
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .