SAP-C02 Question 445
Single answerA company wants to migrate a multi-tier application to AWS. The application consists of a web tier, an application tier, and a database tier. The application requires high availability and automatic failover for the database. The company also wants to minimize operational overhead for database management. Which database solution should you recommend?
- A
Amazon RDS with Multi-AZ deployment
- B
Amazon DynamoDB with global tables
- C
Amazon Aurora with Multi-AZ deployment
- D
Amazon EC2 instances running self-managed MySQL with replication
Show answer and explanation
Correct answer: C
Explanation
Amazon Aurora with Multi-AZ deployment is the best solution because it meets all the requirements: high availability, automatic failover, and minimal operational overhead. Aurora is designed for enterprise-grade applications, providing better performance and automated management features compared to traditional RDS or self-managed databases. While other options may partially meet the requirements, Aurora provides the most comprehensive solution in this scenario.
- A. Incorrect.
Amazon RDS with Multi-AZ deployment provides high availability and failover for a relational database. However, it does not offer the advanced features of Aurora, such as better performance and automated scaling for read replicas.
- B. Incorrect.
Amazon DynamoDB is a NoSQL database and is not suitable for applications requiring relational database features such as complex querying or transactional consistency.
- C. Correct.
Amazon Aurora with Multi-AZ deployment provides high availability, automatic failover, and better performance compared to traditional databases. It also reduces operational overhead by automating tasks such as backups, scaling, and software patching, making it the best choice for a highly available relational database.
- D. Incorrect.
Amazon EC2 instances running self-managed MySQL would require manual setup and maintenance of replication and failover, which increases operational overhead and complexity. This does not align with the company’s goal of minimizing operational overhead.