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.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
Last updated
An enterprise hosts a critical transaction processing application on Google Cloud. The primary database runs on Cloud SQL in the us-central1 region. As part of a business continuity audit, the architecture team must design a cross-region disaster recovery (DR) strategy to protect against a total regional outage while meeting the following technical requirements:
StudyCerts
StudyCertsus-east4 region.Which disaster recovery architecture should you implement to satisfy these requirements?
Create a cross-region read replica in us-east4 as a designated DR replica, configure applications to connect using the Cloud SQL DNS write endpoint, and execute a replica failover to promote the instance during a disaster.
Configure Cloud SQL high availability (HA) with regional persistent disks across zones, and configure an external Application Load Balancer with Serverless NEGs to route database traffic across regions.
Export daily Cloud SQL automated backups to a multi-regional Cloud Storage bucket, and restore the backup to a newly created instance in us-east4 during a disaster.
Set up Database Migration Service (DMS) continuous change data capture (CDC) to a standalone Cloud SQL instance in us-east4, and trigger a migration promote operation during a regional failure.
Create a cross-region read replica in us-east4 as a designated DR replica, configure applications to connect using the Cloud SQL DNS write endpoint, and execute a replica failover to promote the instance during a disaster.
Cloud SQL cross-region replication provides asynchronous replication of database transactions from a primary instance in one region to a read replica in a secondary region. When combined with Cloud SQL Advanced Disaster Recovery (DR) features, administrators can designate a replica for disaster recovery and invoke an immediate replica failover during a regional outage.
us-east4, keeping data up to date and enabling an immediate promotion with minimal replication lag.us-east4 DR replica to assume the primary role.gcloud sql instances promote-replica --failover command coordinates promotion and metadata reconfiguration.us-central1 recovers, Cloud SQL can automatically reconfigure it as a read replica of the new primary.This solution uses Google Cloud's fully managed database replication and disaster recovery lifecycle management. It eliminates custom failover scripting, manual IP address reconfigurations, and manual backup reconfiguration in the target region.
Configure Cloud SQL high availability (HA) with regional persistent disks across zones, and configure an external Application Load Balancer with Serverless NEGs to route database traffic across regions.
Export daily Cloud SQL automated backups to a multi-regional Cloud Storage bucket, and restore the backup to a newly created instance in us-east4 during a disaster.
Set up Database Migration Service (DMS) continuous change data capture (CDC) to a standalone Cloud SQL instance in us-east4, and trigger a migration promote operation during a regional failure.