Question

Your team runs a transactional application backed by a Cloud SQL for PostgreSQL instance in the us-central1 region. A compliance review requires that the database withstand a full regional outage with a recovery point objective (RPO) close to zero and a recovery time objective (RTO) of minutes, not hours. Automated backups are already enabled but stored only in the primary region. Which approach best meets these disaster recovery requirements?

Accepted Answer

Configure a cross-region read replica in a second region and promote it to a standalone primary during a regional outage

Answer

Increase the automated backup frequency and retention, and restore from backup into a new instance in another region if the primary region fails

Answer

Enable a high-availability (regional) configuration so the standby is provisioned in a different zone within us-central1

Answer

Export the database to Cloud Storage in a dual-region bucket on a nightly schedule and import it into a new instance when needed