Answer-first summary for fast verification
Answer: Implement a read replica for the database, directing script queries to it.
The correct answer is B. The development team is experiencing inadequate database performance when a script runs queries against the database. Creating a read replica of the database and configuring the script to query only the read replica will offload the read operations from the primary database instance. This approach improves performance without requiring a complex solution or significant operational overhead, as Amazon RDS manages the replication process and updating of the read replica. Implementing a read replica is a straightforward, effective way to enhance the performance of the primary database for development tasks.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a solutions architect, recommend a solution with the least operational overhead to resolve inadequate database performance during script execution for a company using an Amazon RDS Single-AZ SQL database to store and query movie data.
A
Upgrade to a Multi-AZ DB deployment.
B
Implement a read replica for the database, directing script queries to it.
C
Manually export database entries daily by the development team.
D
Cache common script queries using Amazon ElastiCache.
No comments yet.