Q97 — AWS SAA-C03 Ch.11

Question 97 of 100 | ← Chapter 11

Q797. A package delivery company has an application that uses Amazon EC2 instances and an Amazon Aurora MySQL DB cluster. As the application becomes more popular, EC2 instance usage increases only slightly.DB cluster usage increases at a much faster rate.The company adds a read replica, which reduces the DB cluster usage for a short period of time. However, the load continues to increase. The operations that cause the increase in DB cluster usage are all repeated read statements that are related to delivery details. The company needs to alleviate the effect of repeated reads on the DB cluster.Which solution will meet these requirements MOST cost-effectively?

Correct Answer: A. Implement an Amazon ElastiCache for Redis cluster between the application and the DB cluster.

Explanation

To alleviate the effect of repeated reads on the Amazon Aurora MySQL DB cluster in a cost-effective manner, the recommended solution is:A. Implement an Amazon ElastiCache for Redis cluster between the application and the DB cluster.By implementing an Amazon ElastiCache for Redis cluster between the application and the DB cluster, you can offload the repeated read statements related to delivery details from the DB cluster to the in-memory caching provided by ElastiCache. This reduces the load on the DB cluster and improves the overall performance of the application.Here's why the other options are not the best fit for the given requirements:B. Adding an additional read replica to the DB cluster: While adding read replicas can help distribute the read load, it may not be the most cost-effective solution. Each read replica incurs additional costs, and if the load continues to increase, adding more read replicas may not be scalable or cost-efficient in the long run.C. Configuring Aurora Auto Scaling for the Aurora read replicas: Aurora Auto Scaling can automatically adjust the number of read replicas based on the demand, but it may not directly address the issue of alleviating the effect of repeated reads. Auto Scaling is more suitable for handling variable read workloads rather than reducing the load caused by repeated reads.D. Modifying the DB cluster to have multiple writer instances: Modifying the DB cluster to have multiple writer instances may not be the most cost-effective solution for alleviating the effect of repeated reads. It may introduce complexity and potential consistency issues in the application, and it may not directly address the issue of reducing the load caused by repeated read statements.Therefore, the recommended solution that meets the requirements of alleviating the effect of repeated reads on the DB cluster in a cost-effective manner is:A. Implement an Amazon ElastiCache for Redis cluster between the application and the DB cluster.