A SysOps Administrator is setting up a new production database on Amazon RDS for PostgreSQL. The database must be highly available and support automatic failover to a standby instance in the event of an infrastructure failure or Availability Zone outage. Which configuration will meet these requirements?
- Enable Multi-AZ deployment for the Amazon RDS database instance.Answer
- BDeploy an Amazon RDS Read Replica in a different Availability Zone within the same AWS Region.
- CDeploy an Amazon RDS Read Replica in a different AWS Region and enable cross-region replication.
- DConfigure an Amazon Route 53 failover routing policy pointing to a primary and secondary read replica.
Answer
Enable Multi-AZ deployment for the Amazon RDS database instance.
Enabling Multi-AZ deployment is the correct configuration. It creates a synchronous standby replica in a separate Availability Zone. If the primary instance fails or its Availability Zone becomes unavailable, Amazon RDS automatically modifies the CNAME record of the DB instance to point to the standby replica, providing high availability with zero manual intervention.
Step-by-Step Solution
Key Concept
Amazon RDS Multi-AZ deployments provide automatic failover and high availability by maintaining a synchronous standby replica in a different Availability Zone, whereas Read Replicas are for scalability and use asynchronous replication.
Estimated Time:45s