Question

A financial services company runs a critical transaction-processing application on a single Amazon RDS for PostgreSQL instance in one Availability Zone. During a recent AZ-level infrastructure event, the database became unavailable for several hours, causing an outage. The company needs the database to automatically fail over to another Availability Zone with minimal data loss and no application code changes. Which solution meets these requirements MOST effectively?

Accepted Answer

Enable a Multi-AZ deployment for the RDS instance so a synchronously replicated standby is maintained in a second Availability Zone.

Answer

Create a read replica in a second Availability Zone and point the application to the replica's endpoint during failures.

Answer

Configure automated daily snapshots and restore the database into another Availability Zone when an outage occurs.

Answer

Increase the instance size to a larger instance class to improve the database's resilience to AZ failures.