Intrigued by the art of cloud architecture? Discover how to design, develop, and manage robust, secure, scalable, and dynamic solutions on Google Cloud as you prepare for the Professional Cloud Architect exam!
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
An enterprise is deploying a mission-critical relational database on Google Cloud using Cloud SQL for MySQL. The database design must meet the following disaster recovery and availability requirements:
Which database architecture should you implement?
Cloud SQL High Availability (HA) uses synchronous data replication across two zones within the same region (a primary instance and a standby instance). A cross-region read replica replicates data asynchronously from the primary instance to a distinct secondary Google Cloud region, where it serves read traffic during normal operations and can be manually or programmatically promoted to a standalone read-write primary database during a catastrophic regional disaster.
This architecture pairs synchronous zonal replication for continuous high availability with asynchronous cross-region replication for disaster recovery, perfectly balancing performance, cost, and stringent RTO/RPO objectives.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
StudyCerts
StudyCerts