SAP-C02 Question 640
Single answerAn e-commerce company is using an Amazon RDS MySQL database to handle its transactional data. The company has recently experienced performance issues due to an increase in read traffic. After analyzing the workload, you identify that approximately 80% of the queries are read operations and can tolerate eventual consistency. What is the most cost-effective solution to improve the database performance?
- A
Enable Multi-AZ deployment for the RDS instance.
- B
Migrate the database to Amazon Aurora and use its read replicas.
- C
Create Amazon RDS Read Replicas for the MySQL database.
- D
Migrate the database to Amazon DynamoDB with on-demand capacity.
Show answer and explanation
Correct answer: C
Explanation
The company needs a solution that addresses the high read traffic in a cost-effective manner and can tolerate eventual consistency. Amazon RDS Read Replicas allow read traffic to be distributed across multiple replicas without requiring major changes to the existing application. This makes it the best choice compared to other options, which either do not improve read performance, involve significant migration efforts, or are not as cost-effective.
- A. Incorrect.
Enabling Multi-AZ deployment improves availability and fault tolerance but does not enhance read performance, as the standby instance is not used for read operations.
- B. Incorrect.
Amazon Aurora supports read replicas and offers excellent scalability, but migrating to Aurora may not be the most cost-effective option if the current database setup meets functional requirements.
- C. Correct.
Creating Amazon RDS Read Replicas is a cost-effective and efficient way to offload read traffic from the primary database, and it supports eventual consistency, which matches the workload requirements.
- D. Incorrect.
Migrating to Amazon DynamoDB could provide high performance but requires significant application changes and may not be cost-effective for transactional data that is primarily relational.