SAP-C02 Question 77
Single answerA company is designing a highly available application on AWS that requires a relational database for structured data storage. The database must automatically failover to a secondary instance in case of an availability zone failure and support read replicas for scaling read operations. Which database solution meets these requirements?
- A
Amazon RDS with Multi-AZ configuration and read replicas
- B
Amazon Aurora with Global Database enabled
- C
Amazon DynamoDB with on-demand backup and restore
- D
Amazon RDS with a single Availability Zone deployment
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS with Multi-AZ configuration is specifically designed to provide high availability and automatic failover within a region. When combined with read replicas, it supports both scalability and reliability for relational databases, meeting all the requirements outlined in the scenario. Other options either do not provide relational database capabilities or fail to meet the high availability and failover needs.
- A. Correct.
Amazon RDS with Multi-AZ configuration provides automatic failover to a standby instance in a different availability zone. Additionally, read replicas can be used to scale read operations, making it the correct choice for this scenario.
- B. Incorrect.
Amazon Aurora with Global Database is designed for disaster recovery across regions and read scalability. However, the question specifies availability zone failure, not regional disaster recovery, making this option less suitable.
- C. Incorrect.
Amazon DynamoDB is a NoSQL database service and does not use a relational model. It also lacks built-in failover mechanisms for availability zone failures in a structured relational database context, making it unsuitable for this requirement.
- D. Incorrect.
Amazon RDS with a single Availability Zone deployment does not provide high availability or automatic failover, which is a requirement in the scenario, making it an incorrect choice.