PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #40
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery…
The correct answer is C. Set up read replicas in different zones of the same region as the primary instance with. The requirement is zero data loss (RPO) with minutes RTO for both zonal and regional failures. Cloud SQL for MySQL's HA configuration uses synchronous replication to a standby in a different zone of the same region. Synchronous replication guarantees no data loss (RPO = 0)…
Question
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
Options
- ASet up all read replicas in a different region using asynchronous replication.
- BSet up all read replicas in the same region as the primary instance with synchronous replication.
- CSet up read replicas in different zones of the same region as the primary instance with
- DSet up read replicas in different zones of the same region as the primary instance with
How the community answered
(54 responses)- A7% (4)
- B17% (9)
- C72% (39)
- D4% (2)
Explanation
The requirement is zero data loss (RPO) with minutes RTO for both zonal and regional failures. Cloud SQL for MySQL's HA configuration uses synchronous replication to a standby in a different zone of the same region. Synchronous replication guarantees no data loss (RPO = 0) because writes are committed to both primary and standby before acknowledging the client. Automatic failover handles zone outages within minutes (RTO in minutes). Option A (cross-region with async) would have data loss due to replication lag. Option B (same region, synchronous) likely refers to HA but without the multi-zone protection. Option D (same region but asynchronous) risks data loss during failover.
Topics
Community Discussion
No community discussion yet for this question.