SAP-C02 Question 297
Single answerYou are designing a highly available web application deployed across multiple AWS Regions. The application uses an Amazon RDS database in each Region and a Route 53 record to route user traffic to the nearest Region. However, you need to ensure that if a Regional database becomes unavailable, the application in that Region automatically fails over to use the database in another Region. Which solution should you implement to meet this requirement while minimizing operational overhead?
- A
Use Amazon RDS Global Databases to replicate data across Regions and configure application logic to read from the nearest healthy database.
- B
Implement a custom solution using Amazon S3 and AWS Lambda to replicate the database between Regions and failover when needed.
- C
Use Amazon Aurora Global Database to replicate data across Regions and configure the application to automatically fail over to the secondary Region.
- D
Set up Amazon RDS read replicas in each Region and use Route 53 health checks to fail over to a healthy Region when needed.
Show answer and explanation
Correct answer: C
Explanation
Amazon Aurora Global Database is the best solution for this scenario because it is designed to replicate data across multiple Regions with minimal latency and supports automatic failover in the event of a failure. This minimizes operational overhead and ensures high availability. Other options either introduce unnecessary complexity or do not meet the requirements for cross-Region failover.
- A. Incorrect.
This option is incorrect because Amazon RDS Global Databases are designed for specific workloads and do not support automatic application failover. The application logic would also require significant customizations to determine the nearest healthy database.
- B. Incorrect.
This option is incorrect because creating a custom solution using Amazon S3 and AWS Lambda to replicate databases introduces unnecessary complexity and operational overhead. It is not a recommended approach for cross-Region failover.
- C. Correct.
This option is correct because Amazon Aurora Global Database is specifically designed for cross-Region replication with minimal latency. It also supports automatic failover to the secondary Region in case of a failure, which minimizes operational overhead.
- D. Incorrect.
This option is incorrect because Amazon RDS read replicas are not designed for cross-Region failover in this manner. Route 53 health checks can determine the status of an endpoint, but they cannot manage database failover or replication.