SAA-C03 Question 192
Single answerA company runs a web application with a primary Amazon RDS database instance in a single Availability Zone. The company needs to ensure high availability and automatic failover for the database in case of an Availability Zone outage. What should the Solutions Architect do to meet these requirements?
- A
Enable Multi-AZ deployment for the RDS instance.
- B
Create a read replica in another Availability Zone.
- C
Set up Amazon RDS Proxy to manage failover.
- D
Use Amazon Route 53 to route traffic to the database in another Region.
Show answer and explanation
Correct answer: A
Explanation
To achieve high availability and automatic failover for an Amazon RDS database, enabling Multi-AZ deployment is the recommended approach. This ensures that a standby instance is deployed in a different Availability Zone and automatically promoted if the primary instance becomes unavailable. Other options, such as read replicas, require manual intervention and are not designed for automatic failover scenarios.
- A. Correct.
Correct. Enabling Multi-AZ deployment for Amazon RDS ensures that a standby instance is created in another Availability Zone, allowing for automatic failover in the event of an outage.
- B. Incorrect.
Incorrect. A read replica is used to scale read operations and does not provide automatic failover. It requires manual promotion to act as a standalone database.
- C. Incorrect.
Incorrect. Amazon RDS Proxy improves application availability and performance but does not handle automatic failover for a primary RDS instance.
- D. Incorrect.
Incorrect. Amazon Route 53 is used for DNS-based routing and cannot directly provide failover for RDS databases. It is also not designed for Availability Zone-specific failover.