AWS Certified Solutions Architect – Associate (SAA-C03) — Question 212

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

Option C is correct because creating a read replica in another Region allows the data to be available with low latency and minimal operational overhead. Option A requires more management of EC2 instances, which increases operational complexity. Option B provides high availability but does not meet the cross-Region requirement. Option D involves snapshots that are not automatically available for real-time access, making it less suitable for continuous availability.