nerdexam
Google

PROFESSIONAL-CLOUD-ARCHITECT · Question #365

Your ecommerce platform uses a regional Cloud SQL for PostgreSQL database to store critical order information. The business requests a recovery time objective (RTO) of less than 10 minutes and a recov

The correct answer is C. Configure the Cloud SQL instance with a cross-region read replica. In a disaster, promote the. A cross-region read replica continuously replicates data from the primary Cloud SQL instance with minimal lag, meeting the 2-minute RPO requirement. Promoting the replica during a regional outage is a supported, straightforward operation that enables recovery well within the 10-m

Submitted by kevin_r· Mar 30, 2026Ensuring solution and operations reliability

Question

Your ecommerce platform uses a regional Cloud SQL for PostgreSQL database to store critical order information. The business requests a recovery time objective (RTO) of less than 10 minutes and a recovery point objective (RPO) of 2 minutes to ensure business continuity in the event of a full regional outage. You need to design a disaster recovery strategy for the Cloud SQL database that meets the business's strict RTO and RPO requirements. Your design must avoid operational complexity. What should you do?

Options

  • ASchedule hourly automated backups of the Cloud SQL instance to a multi-regional Cloud Storage
  • BUse Database Migration Service to continuously replicate the database to another instance in a
  • CConfigure the Cloud SQL instance with a cross-region read replica. In a disaster, promote the
  • DConfigure the primary instance for high availability (HA). In the event of a regional outage, trigger

How the community answered

(35 responses)
  • A
    11% (4)
  • B
    6% (2)
  • C
    63% (22)
  • D
    20% (7)

Explanation

A cross-region read replica continuously replicates data from the primary Cloud SQL instance with minimal lag, meeting the 2-minute RPO requirement. Promoting the replica during a regional outage is a supported, straightforward operation that enables recovery well within the 10-minute RTO, while keeping the architecture simple and operationally manageable.

Topics

#Cloud SQL#cross-region read replica#disaster recovery#RTO/RPO

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-ARCHITECT Practice