Answer-first summary for fast verification
Answer: Implement a read replica of the primary database for business analysts to run their queries.
The correct answer is C: Implement a read replica of the primary database for business analysts to run their queries. Read replicas are designed to offload read traffic from the primary database, improving performance without major changes to the existing application. This solution is cost-effective and easy to implement, addressing the performance degradation caused by the increased number of read-only SQL queries.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
An e-commerce company is experiencing performance issues due to increased read-only SQL queries from business analysts on an Amazon RDS-based application. What is the recommended solution with minimal web application changes?
A
Use Amazon DynamoDB for data export and query execution by business analysts.
B
Utilize Amazon ElastiCache for data loading and query execution by business analysts.
C
Implement a read replica of the primary database for business analysts to run their queries.
D
Migrate data to an Amazon Redshift cluster for query execution by business analysts.
No comments yet.