Question #1260
A global e-commerce platform uses a PostgreSQL database to manage real-time inventory data. The platform requires continuous availability of its database across multiple AWS Regions with minimal operational complexity. Which solution fulfills these requirements?
Deploy a PostgreSQL cluster on Amazon EC2 instances across multiple Regions using a custom replication setup.
Use Amazon RDS for PostgreSQL with Multi-AZ deployment enabled in a single Region.
Configure an Amazon RDS for PostgreSQL primary instance and create a cross-Region read replica in another AWS Region.
Implement automated backups of an Amazon RDS for PostgreSQL instance and copy backups to a secondary Region.
Explanation
Option C is correct because Amazon RDS for PostgreSQL supports cross-Region read replicas, which enable asynchronous replication of data to another AWS Region. This setup ensures real-time inventory data availability in multiple Regions and allows for quick promotion of the read replica to a standalone instance during a primary Region outage.
Option A is incorrect because deploying a custom PostgreSQL cluster on EC2 introduces high operational complexity for replication and maintenance. Option B fails to address cross-Region availability, as Multi-AZ only provides redundancy within a single Region. Option D relies on backups, which require manual restoration and do not support real-time availability. Key points: Cross-Region read replicas automate replication, minimize operational effort, and ensure continuous availability across Regions.
Answer
The correct answer is: C