ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 361 - SAA-C03 discussion

Report
Export

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.
Answers
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.
Answers
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.
Answers
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
Answers
D.
Copy the data into an Amazon Redshift cluster and have the business analysts run their queries
Suggested answer: C

Explanation:

Creating a read replica of the primary RDS database will offload the read-only SQL queries from the primary database, which will help to improve the performance of the web application. Read replicas are exact copies of the primary database that can be used to handle read-only traffic, which will reduce the load on the primary database and improve the performance of the web application. This solution can be implemented with minimal changes to the existing web application, as the business analysts can continue to run their queries on the read replica without modifying the code.

asked 16/09/2024
Josue Medrano Caldera
21 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first