Question

A financial services company is designing a new payment-processing platform that must remain available even if an entire AWS Region becomes unavailable. Business requirements specify an RTO of under 1 minute and an RPO of near zero (no more than a few seconds of data loss). The workload has a relational data model with strong consistency needs and moderate write volume distributed across users in North America and Europe. Which database architecture best meets these requirements?

Accepted Answer

Deploy an Amazon Aurora Global Database with a primary Region and a secondary Region using managed cross-Region replication with typical replica lag under one second, enabling managed planned or unplanned failover.

Answer

Deploy Amazon Aurora PostgreSQL in a single Region with a Multi-AZ cluster, and take automated snapshots copied to a second Region every 5 minutes for disaster recovery.

Answer

Deploy Amazon RDS for PostgreSQL with a cross-Region read replica, and promote the replica manually to primary if the primary Region fails.

Answer

Deploy DynamoDB global tables across both Regions to achieve multi-Region active-active writes with automatic conflict resolution.