GCP Professional Cloud Architect Practice Question

Your company sells event tickets worldwide. Leadership requires the new Google Cloud architecture to keep the MySQL transactional database available even if an entire region fails. The business has set an RTO of 15 minutes and an RPO of 5 minutes, and it wants the lowest ongoing cost that still meets these targets with minimal operational overhead. Which data-layer design should you implement?

Create a Cloud SQL for MySQL instance with regional high availability and add a cross-region read replica that you can promote if the primary region fails.
Deploy self-managed MySQL on Compute Engine managed instance groups in two zones and use nightly dump-and-restore scripts to synchronize data between regions.
Migrate the database to a multi-region Cloud Spanner instance with three read replicas across continents.
Run Cloud SQL for MySQL in a single region with automated backups and daily exports to Cloud Storage in a second region.

Report Issue

Answer Description

A Cloud SQL instance configured for regional high availability stores two synchronous copies in separate zones, giving an RPO close to zero and an automatic failover that meets a sub-minute RTO for zonal incidents. Adding a cross-region read replica keeps an asynchronous copy in a second region; promotion of that replica during a regional outage can be completed well inside the 15-minute RTO while preserving an RPO of only a few seconds to minutes, satisfying both objectives. This approach is markedly less expensive and simpler to operate than a multi-region Cloud Spanner deployment, while the other MySQL alternatives rely on daily or nightly dumps that would miss the 5-minute RPO and require substantial manual effort in a disaster.

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.