AWS Certified Solutions Architect – Associate (SAA-C02) — Question 117

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?

Answer options

• 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.

Correct answer: C

Explanation

Creating a read replica of the primary database allows the business analysts to run their read-only SQL queries without impacting the performance of the main database. This solution effectively offloads read traffic while requiring minimal changes to the existing application. The other options involve more significant architectural changes or do not specifically address the performance issue caused by increased read queries.