AWS Certified Solutions Architect – Professional — Question 982

A company's solutions architect is designing a disaster recovery (DR) solution for an application that runs on AWS. The application uses PostgreSQL 11.7 as its database. The company has an RPO of 30 seconds. The solutions architect must design a DR solution with the primary database in the us-east-1 Region and the failover database in the us-west-2 Region.
What should the solutions architect do to meet these requirements with minimum application change?

Answer options

• A. Migrate the database to Amazon RDS for PostgreSQL in us-east-1. Set up a read replica in us-west-2. Set the managed RPO for the RDS database to 30 seconds.
• B. Migrate the database to Amazon RDS for PostgreSQL in us-east-1. Set up a standby replica in an Availability Zone in us-west-2. Set the managed RPO for the RDS database to 30 seconds.
• C. Migrate the database to an Amazon Aurora PostgreSQL global database with the primary Region as us-east-1 and the secondary Region as us-west-2. Set the managed RPO for the Aurora database to 30 seconds.
• D. Migrate the database to Amazon DynamoDB in us-east-1. Set up global tables with replica tables that are created in us-west-2.

Correct answer: C

Explanation

Amazon Aurora PostgreSQL global databases natively support setting a managed Recovery Point Objective (RPO) of up to 30 seconds for cross-Region replication, which perfectly fits the requirements while remaining PostgreSQL-compatible. Amazon RDS for PostgreSQL does not feature a managed RPO configuration for its replicas, and Multi-AZ standby deployments cannot cross AWS Regions. Migrating to Amazon DynamoDB would require a complete rewrite of the database layer from relational to NoSQL, violating the requirement for minimum application changes.