You’ve currently developed an application that makes use of AWS RDS – MySQL service. During the testing phase, you can see that the database is taking a performance hit. After further investigation, you can see that the same queries are causing the performance bottleneck on the application. Which of the following development steps should be taken to resolve this issue?

Answer options:

A.Use the Multi-AZ feature for the underlying database.
B.Change the underlying instance type for the database.
C.Use SQS queues to store the results of the query for faster access.
D.Use AWS ElastiCache to store the results of the query for faster access.

Answer – D
Option A is invalid because this is used for the high availability of the database.
Option B is invalid because we don’t know the server`s current configuration. We guess that this could be the underlying issue.
Option C is invalid because this service is normally used for messaging across distributed components of an application.
The AWS Documentation states the following which makes sense to use AWS ElasticCache for this scenario.
Amazon ElastiCache offers fully managed Redis and Memcached. Seamlessly deploy, operate, and scale popular open source compatible in-memory data stores. Build data-intensive apps or improve your existing apps` performance by retrieving data from high throughput and low latency in-memory data stores.
For more information on AWS ElastiCache, please refer to the below link-
https://aws.amazon.com/elasticache/