Question

A financial services company runs a production Amazon RDS for PostgreSQL database in the us-east-1 Region. Compliance requires that, in the event of a full Regional outage, the company must be able to restore the database in us-west-2 with a Recovery Point Objective (RPO) of no more than 1 hour and a Recovery Time Objective (RTO) of a few hours. The CloudOps team wants a managed, centrally governed solution that requires minimal custom scripting. Which approach best meets these requirements?

Accepted Answer

Create an AWS Backup plan with a backup rule that runs hourly and configure a cross-Region copy action to copy each recovery point to us-west-2.

Answer

Enable automated RDS backups with a 7-day retention period and rely on point-in-time recovery, which automatically replicates to us-west-2.

Answer

Create a cross-Region read replica of the RDS instance in us-west-2 and promote it manually only after a Regional failure is confirmed.

Answer

Write a Lambda function triggered every 6 hours to create a manual DB snapshot and copy it to us-west-2 using the RDS API.