Answer-first summary for fast verification
Answer: Implement a read replica to offload reporting queries.
The correct answer is A: 'Implement a read replica to offload reporting queries.' Creating a read replica allows you to offload the reporting queries to another database instance, thereby reducing the load on the primary database used for order processing. This helps in eliminating timeouts without needing to restrict query access for employees. Option B is more complex and not necessary just for handling reporting queries. Option C involves a significant architecture change that may not be warranted in this scenario. Option D does not solve the problem during peak hours when the reports might also be needed.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can a solutions architect address the issue of timeouts during order processing in an Amazon RDS MySQL application, caused by long-running employee reporting queries, without restricting query access?
A
Implement a read replica to offload reporting queries.
B
Deploy a read replica alongside the primary DB for application distribution.
C
Switch the application to Amazon DynamoDB using on-demand capacity.
D
Reschedule reporting queries to off-peak hours.