SAA-C03 Question 524
Single answerA company is running a critical web application that relies on an Amazon RDS database in a single Availability Zone. Due to increasing traffic, the company is concerned about database reliability and wants to ensure high availability with minimal application downtime. Which of the following solutions should the company implement?
- A
Enable Multi-AZ deployment for the RDS instance.
- B
Create read replicas in multiple Availability Zones.
- C
Migrate the database to an Amazon DynamoDB table.
- D
Set up a cross-region read replica for the RDS instance.
Show answer and explanation
Correct answer: A
Explanation
The best solution for ensuring high availability for an Amazon RDS database is to enable Multi-AZ deployment. This feature automatically replicates the database to a standby instance in a different Availability Zone and provides automatic failover support, ensuring minimal downtime during failures. Other options like read replicas and DynamoDB are either not designed for high availability or require significant architectural changes.
- A. Correct.
Enabling Multi-AZ deployment for the RDS instance ensures high availability by automatically setting up a secondary database in a different Availability Zone and performing automatic failover in case of a primary instance failure. This solution minimizes downtime.
- B. Incorrect.
Read replicas are designed to improve read performance and are not intended to provide high availability. They do not provide automatic failover capabilities.
- C. Incorrect.
Migrating to DynamoDB is not necessary in this scenario. While DynamoDB offers high availability, it requires significant application changes and is not a direct solution to improve RDS availability.
- D. Incorrect.
Cross-region read replicas improve read performance for geographically distributed users but do not provide high availability within the same region or automatic failover capabilities.