
Ultimate access to all questions.
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.