Explanation:
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.
Ultimate access to all questions.
No comments yet.
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.