SOA-C02 Question 66
Select 3Your organization runs a critical application on an Amazon RDS MySQL database. To improve read performance and ensure high availability, you have been tasked with implementing read replicas. Additionally, you want to ensure that in case of a regional failure, your application can fail over to a replica in another region. What steps should you take to meet these requirements?
- A
Create an Amazon RDS read replica in the same AWS Region as your primary database to handle read traffic.
- B
Enable automatic failover for the Amazon RDS read replica to ensure high availability.
- C
Create an Amazon RDS read replica in a different AWS Region to serve as a disaster recovery solution.
- D
Promote the cross-region read replica to a standalone database during a regional failure.
- E
Use Amazon Aurora Global Database instead of Amazon RDS for built-in cross-region failover capabilities.
Show answer and explanation
Correct answers: A, C, D
Explanation
To meet the requirements, you should create a read replica in the same region to improve read performance and another cross-region read replica for disaster recovery. Since RDS read replicas do not support automatic failover, you must manually promote the cross-region replica to a standalone database during a regional failure. Aurora Global Database is an alternative solution but is not applicable to this scenario as it specifically involves Amazon RDS MySQL.
- A. Correct.
Correct. Creating a read replica in the same region offloads read traffic from the primary database and improves read performance.
- B. Incorrect.
Incorrect. Amazon RDS read replicas do not support automatic failover. Failover is only available with Multi-AZ deployments.
- C. Correct.
Correct. Creating a cross-region read replica serves as a disaster recovery solution in case of a regional failure.
- D. Correct.
Correct. During a regional failure, promoting a cross-region read replica to a standalone database ensures your application can continue operating.
- E. Incorrect.
Incorrect. While Amazon Aurora Global Database offers built-in cross-region failover, the scenario specifically involves using Amazon RDS MySQL, not Aurora.