A Company is currently hosting an application that connects to a MySQL AWS RDS Instance. The application behaves fine when there are 20 lookups against the database. When the lookups start to increase, the performance of the application starts to degrade. Which of the following can be added to the architecture to alleviate the performance issue?

Answer options:

A.Create a Read Replica for the database.
B.Enable Multi-AZ for the database.
C.Place the database behind a Cloudfront distribution.
D.Create a snapshot of the database.

Answer – A
Option B is incorrect since this is used for high availability of the database.
Option C is incorrect since Cloudfront is used for web distributions.
Option D is incorrect since this is used for backups of databases.
The AWS Documentation mentions the following.
Amazon RDS Read Replicas provide enhanced performance and durability for database (DB) instances. This feature makes it easy to elastically scale out beyond a single DB instance for read-heavy database workloads beyond the capacity constraints of a single DB instance. You can create one or more replicas of a given source DB Instance and serve high-volume application read traffic from multiple copies of your data, thereby increasing aggregate read throughput.
For more information on AWS Read Replica’s, please refer to the below URL-
https://aws.amazon.com/rds/details/read-replicas/