Explanation:
Correct Answer: C - Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance. Create a read replica in another Region.
Why this is correct:
Multi-Region Availability: The requirement states that data must be "available and online across multiple AWS Regions at all times." Creating a read replica in another Region provides a live, read-only copy of the database in a different Region.
Least Operational Overhead: Amazon RDS manages the replication process automatically. Once configured, RDS handles the ongoing replication, monitoring, and maintenance with minimal operational overhead.
High Availability: While the read replica is read-only, it can be promoted to a standalone database if needed, providing disaster recovery capabilities.
Analysis of other options:
A. PostgreSQL cluster on Amazon EC2 instances:
B. RDS with Multi-AZ feature:
D. RDS with DB snapshots copied to another Region:
Key AWS Concepts:
Best Practice: For multi-region availability with minimal operational overhead, Amazon RDS cross-region read replicas are the recommended approach for PostgreSQL databases on AWS.
Ultimate access to all questions.
No comments yet.
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?
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.