AWS Certified Solutions Architect – Associate (SAA-C03) — Question 232

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 read-only SQL queries to be offloaded from the primary instance, thus improving overall performance. The other options involve more significant changes or different architectures, which may not be ideal for the current setup and could introduce additional complexity or costs.