SAA-C03 Question 434
Single answerA company is running a highly available web application in a VPC. The application is hosted on Amazon EC2 instances behind an Application Load Balancer (ALB) and uses an Amazon RDS database for persistence. The company wants to ensure that the database is highly available and can automatically failover in case of an instance failure. Which solution meets these requirements?
- A
Use a Multi-AZ deployment for the Amazon RDS database.
- B
Deploy the database on Amazon EC2 instances with replication configured between instances.
- C
Use Amazon RDS Read Replicas to provide high availability.
- D
Configure the database in a single Availability Zone and back it up using AWS Backup.
Show answer and explanation
Correct answer: A
Explanation
The best way to ensure high availability and automatic failover for an Amazon RDS database is to use a Multi-AZ deployment. This setup replicates the database to a standby instance in another Availability Zone and provides automatic failover capabilities. Other options, such as using read replicas or EC2-based databases, do not meet the high availability and failover requirements as effectively.
- A. Correct.
This is the correct answer. Amazon RDS Multi-AZ deployments provide high availability by automatically replicating data to a secondary instance in a different Availability Zone and automatically failing over in case of a primary instance failure.
- B. Incorrect.
This is not the best solution because managing databases on Amazon EC2 instances requires significant operational overhead, and it does not provide automatic failover or high availability out of the box.
- C. Incorrect.
Amazon RDS Read Replicas are designed to improve read performance and are not intended for high availability or automatic failover.
- D. Incorrect.
Configuring the database in a single Availability Zone does not ensure high availability, and while backups help with data recovery, they do not provide automatic failover in case of an instance failure.