AWS Certified Solutions Architect – Associate (SAA-C02) — Question 450

An online learning company is migrating to the AWS Cloud. The company maintains its student records in a PostgreSQL database. The company needs a solution in which its data is available and online across multiple AWS Regions at all times.
Which solution will meet these requirements with the LEAST amount of operational overhead?

Answer options

• A. Migrate the PostgreSQL database to a PostgreSQL cluster on Amazon EC2 instances.
• B. Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance with the Multi-AZ feature turned on.
• C. Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance. Create a read replica in another Region.
• D. Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance. Set up DB snapshots to be copied to another Region.

Correct answer: C

Explanation

Amazon RDS for PostgreSQL supports cross-Region read replicas, which ensures data is online and readable in another Region with minimal operational overhead. Option A introduces significant management overhead by using EC2. Option B (Multi-AZ) only provides high availability within a single Region, and Option D (snapshots) does not keep the data online and immediately accessible in the secondary Region without a manual restore process.