An ecommerce company has noticed performance degradation of its Amazon RDS based web application. The performance degradation is attributed to an increase in the number of read-only SQL queries triggered by business analysts A solutions architect needs to solve the problem with minimal changes to the existing web application

An ecommerce company has noticed performance degradation of its Amazon RDS based web application. The performance degradation is attributed to an increase in the number of read-only SQL queries triggered by business analysts A solutions architect needs to solve the problem with minimal changes to the existing web application

What should the solutions architect recommend”
A . Export the data to Amazon DynamoDB and have the business analysts run their queries
B . Load the data into Amazon ElastiCache and have the business analysts run their queries
C . Create a read replica of the primary database and have the business analysts run their queries
D . Copy the data into an Amazon Redshift cluster and have the business analysts run their queries

View Answer

Answer: C