SOA-C02 Question 85
Single answerA company is hosting a critical database on Amazon RDS. The database must have high availability and automatic failover capabilities to ensure minimal downtime in case of an infrastructure failure. What deployment configuration should you recommend?
- A
Deploy the database in a single Availability Zone to reduce costs.
- B
Enable Multi-AZ deployment for Amazon RDS.
- C
Configure Amazon RDS Read Replicas in a different Availability Zone.
- D
Use Amazon EC2 instances with databases configured in each Availability Zone.
Show answer and explanation
Correct answer: B
Explanation
Multi-AZ deployment for Amazon RDS is the best choice for applications requiring high availability and automatic failover. It ensures that a standby database instance is maintained in a separate Availability Zone and is automatically promoted to the primary role in case of failure. This reduces downtime and provides a managed solution for critical workloads.
- A. Incorrect.
Deploying the database in a single Availability Zone reduces costs but does not provide high availability or automatic failover capabilities. This option is unsuitable for critical systems requiring redundancy.
- B. Correct.
Enabling Multi-AZ deployment for Amazon RDS provides automatic failover support and high availability. In a Multi-AZ configuration, Amazon RDS synchronously replicates data to a standby instance in a different Availability Zone, ensuring minimal downtime.
- C. Incorrect.
Amazon RDS Read Replicas are used for read scaling and do not provide automatic failover or high availability. They are not suitable for critical systems requiring these features.
- D. Incorrect.
Using Amazon EC2 with custom databases in each Availability Zone requires manual setup and management, including replication and failover logic. This approach is complex and does not leverage the automatic failover capabilities provided by Amazon RDS Multi-AZ deployments.