What should the solutions architect recommend?

By:
In: SAA-C02
Tagged:
With: 1 Comment
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?

Export the data to Amazon DynamoDB and have the business analysts run their queries.

Load the data into Amazon ElastiCache and have the business analysts run their queries.

Create a read replica of the primary database and have the business analysts run their queries.

Copy the data into an Amazon Redshift cluster and have the business analysts run their queries.

Explanations:

Exporting data to Amazon DynamoDB would require significant changes to the existing application and data model, making it less ideal for minimal changes.

Loading data into Amazon ElastiCache is not suitable for running SQL queries as it is primarily an in-memory data store optimized for caching, not querying.

Creating a read replica allows the primary database to offload read queries, thus improving performance without major changes to the application.

Copying data into an Amazon Redshift cluster is not ideal for read-only SQL queries from business analysts, as it requires significant changes and is better suited for analytics workloads.

2025-10-14

1 Comment

  1. Tiffany
    Author

    I figure that the answer is:
    Create a read replica of the primary database and have the business analysts run their queries.

Leave a Reply

Your email address will not be published. Required fields are marked *

four × one =