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 runs a mission-critical database workload on a primary Cloud SQL instance located in us-central1. To achieve a low Recovery Time Objective (RTO) and Recovery Point Objective (RPO) in the event of a regional disaster, the team configured a cross-region disaster recovery (DR) replica in us-east1 and connected their applications using a Cloud SQL DNS write endpoint.
A sudden regional outage occurs in us-central1, rendering the primary database instance completely inaccessible.
Which failover procedure should the cloud architect execute to restore write operations in the secondary region with minimal application downtime?
Execute a planned switchover operation on the DR replica to guarantee zero data loss before redirecting the DNS write endpoint.
Restore the latest automated backup to a new Cloud SQL instance in us-east1 and update the application connection strings to point to the new IP address.
Promote the designated DR replica using the replica failover operation (gcloud sql instances promote-replica REPLICA_NAME --failover), allowing the DNS write endpoint to automatically point to the new primary instance.
Promote the DR replica using the standard promotion command (gcloud sql instances promote-replica REPLICA_NAME) without the failover flag, then delete the failed primary instance.
Execute a planned switchover operation on the DR replica to guarantee zero data loss before redirecting the DNS write endpoint.
Restore the latest automated backup to a new Cloud SQL instance in us-east1 and update the application connection strings to point to the new IP address.
Promote the designated DR replica using the replica failover operation (gcloud sql instances promote-replica REPLICA_NAME --failover), allowing the DNS write endpoint to automatically point to the new primary instance.
Cloud SQL replica failover is an automated disaster recovery mechanism that promotes an existing cross-region read replica to assume the role of the primary instance immediately during an unexpected outage or disaster.
StudyCerts
StudyCertsgcloud sql instances promote-replica REPLICA_NAME --failover immediately promotes the replica to a standalone primary database without waiting for synchronization steps that require an accessible primary instance.This approach directly satisfies aggressive Recovery Time Objectives (RTO) by minimizing administrative overhead and eliminating manual configuration changes across application fleets.
Promote the DR replica using the standard promotion command (gcloud sql instances promote-replica REPLICA_NAME) without the failover flag, then delete the failed primary instance.