Question #1244
A company is deploying a PostgreSQL database on Amazon RDS and requires the setup to maximize uptime and ensure continuous operation during an Availability Zone failure. Which AWS configuration should be implemented to satisfy these requirements?
Amazon RDS configured in a single Availability Zone
Automated backups with Amazon RDS snapshots
Amazon RDS Multi-AZ deployment
Using AWS Database Migration Service (AWS DMS) for replication
Explanation
The correct answer is C. Amazon RDS Multi-AZ deployment.
Why C is correct:
- Multi-AZ deploys a primary database instance in one AZ and a synchronous standby replica in another AZ. During an AZ failure, RDS automatically fails over to the standby, minimizing downtime and ensuring continuous operation.
- This configuration is explicitly designed for high availability (HA) and fault tolerance against AZ failures.
Why other options are incorrect:
- A: A single-AZ deployment lacks redundancy, making the database vulnerable to AZ outages.
- B: Automated backups and snapshots support recovery but do not prevent downtime during an AZ failure.
- D: AWS DMS is used for database migration or cross-region replication, not for HA within the same region.
Key Points:
- Multi-AZ is AWS's HA solution for RDS, ensuring automatic failover.
- Backups (B) and DMS (D) address data recovery and migration, not uptime during AZ failures.
- Single-AZ (A) does not meet HA requirements.
Answer
The correct answer is: C