A solutions architect is designing the database tier for a critical web application. The application will use an Amazon RDS for PostgreSQL DB instance and requires high availability with automatic failover within a single AWS Region.
Which two options should the solutions architect implement to meet these requirements? (Select two.)
- Deploy the RDS DB instance in a Multi-AZ configuration to enable synchronous replication to a standby instance in a different Availability Zone.Answer
- Configure the application to connect using the primary DB instance DNS endpoint, which AWS automatically updates to point to the standby instance during failover.Answer
- CConfigure an RDS Read Replica in a different Availability Zone and update the application connection string to write to the replica if the primary instance fails.
- DSet up a Warm Standby DB instance in another AWS Region and use Route 53 latency-based routing to automatically redirect write traffic if the primary region goes offline.
- EDeploy the database in a Pilot Light configuration with a second scaled-down standby DB instance in another Availability Zone that is manually turned on during a failure.
Answer
Deploy the RDS DB instance in a Multi-AZ configuration to enable synchronous replication, and configure the application to connect using the primary DB instance DNS endpoint.
The correct options are deploying the RDS DB instance in a Multi-AZ configuration and configuring the application to connect using the primary DB instance DNS endpoint. Multi-AZ configurations provide synchronous replication and automatic failover to a standby instance in another Availability Zone. During failover, AWS automatically updates the DNS record of the DB instance endpoint, allowing the application to connect to the new primary instance without code or configuration changes.
Step-by-Step Solution
Key Concept
Amazon RDS Multi-AZ High Availability and Failover Mechanics