SAP-C02 Question 48
Select 2A company is running a multi-tier web application on AWS, consisting of an Application Load Balancer (ALB) in front of a fleet of Amazon EC2 instances. The backend stores data in an Amazon RDS MySQL database. They are experiencing intermittent performance issues with their application during periods of high traffic. After analysis, it is determined that the RDS database is becoming a bottleneck due to high read requests. As a solutions architect, what combination of actions should you take to address the issue while minimizing operational overhead?
- A
Enable Amazon RDS Read Replicas and configure the application to distribute read traffic between the primary database and the read replicas.
- B
Increase the instance size of the Amazon RDS database to handle more requests.
- C
Implement Amazon ElastiCache in front of the database to cache frequently accessed queries and reduce the load on the database.
- D
Migrate the database to Amazon DynamoDB to achieve better performance under high traffic.
- E
Enable Multi-AZ for the RDS database to improve scalability and handle the load.
Show answer and explanation
Correct answers: A, C
Explanation
To resolve the performance bottleneck caused by high read traffic, the best approach is to offload the read requests from the primary RDS instance. RDS Read Replicas allow you to distribute read traffic to multiple replicas, while Amazon ElastiCache provides a caching layer to serve frequently accessed data quickly, further reducing the load on the database. These solutions minimize operational overhead and are well-suited for handling high traffic scenarios without requiring a complete architectural overhaul.
- A. Correct.
Correct: Enabling Amazon RDS Read Replicas will offload read traffic from the primary database, reducing bottlenecks during high traffic periods.
- B. Incorrect.
Incorrect: Increasing the instance size of the RDS database may temporarily address the issue but does not scale effectively for read-heavy workloads and incurs higher costs.
- C. Correct.
Correct: Implementing Amazon ElastiCache provides an in-memory caching layer, reducing the load on the database by serving frequently accessed data quickly.
- D. Incorrect.
Incorrect: Migrating to Amazon DynamoDB is not suitable for this use case as it would require a significant redesign of the application and is not a direct solution to the bottleneck caused by read traffic.
- E. Incorrect.
Incorrect: Enabling Multi-AZ improves database availability and failover capabilities but does not improve scalability or help with performance under high read traffic.