DOP-C02 Question 152
Select 2You are managing an application that uses an Amazon RDS MySQL database. The application requires high availability and automatic failover to minimize downtime. Which combination of actions should you take to ensure this setup is resilient and meets the requirements?
- A
Enable Multi-AZ deployment for the Amazon RDS instance.
- B
Configure a read replica in a different AWS Region.
- C
Set up automated backups for the RDS instance.
- D
Deploy the RDS instance in a single availability zone to reduce latency.
- E
Use Route 53 with health checks to reroute traffic in case of a failure.
Show answer and explanation
Correct answers: A, E
Explanation
To ensure high availability and automatic failover for Amazon RDS, you should enable Multi-AZ deployment, which provides automatic failover to a standby instance in a different Availability Zone. Additionally, Route 53 can be used with health checks to reroute traffic in the event of a failure. Other options, while valuable in specific scenarios, do not directly address the requirements for high availability and automatic failover.
- A. Correct.
Enabling Multi-AZ deployment ensures high availability by automatically creating a standby instance in a different Availability Zone and managing failover automatically in case of an issue.
- B. Incorrect.
Configuring a read replica in a different region is helpful for disaster recovery or read scaling, but it does not provide automatic failover or high availability.
- C. Incorrect.
Automated backups are important for data recovery but do not contribute to automatic failover or high availability.
- D. Incorrect.
Deploying the RDS instance in a single availability zone reduces redundancy and does not meet the high availability requirement.
- E. Correct.
Using Route 53 with health checks can help redirect traffic to the healthy endpoint during a failover scenario, ensuring minimal downtime.