Answer-first summary for fast verification
Answer: Implement a read replica for offloading query load from the primary database.
The best solution with the least operational overhead is to create a read replica of the database and configure the script to query only the read replica. This solution improves performance by offloading read queries from the primary database to the read replica, which minimizes the impact on the primary database while the script is running. Option A increases availability but does not address read performance. Option C requires manual intervention and does not align with the requirement for minimal operational overhead. Option D, while helpful for caching, may not address all the frequent queries and adds extra complexity.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A company's SQL database on an Amazon RDS Single-AZ instance is experiencing performance issues during script execution, which records new movie additions. The script must provide a total count during business hours. As a solutions architect, recommend a solution with minimal operational overhead to address the performance impact on development tasks.
A
Upgrade to a Multi-AZ DB deployment for higher availability.
B
Implement a read replica for offloading query load from the primary database.
C
Manually export database entries daily for script processing outside of business hours.
D
Leverage Amazon ElastiCache to cache and speed up the execution of common script queries.