Q83 — AWS SAA-C03 Ch.11

Question 83 of 100 | ← Chapter 11

Q783. A company hosts a database that runs on an Amazon RDS instance that is deployed to multiple Availability Zones. The company periodically runs a script against the database to report new entries that are added to the database. The script that runs against the database negatively affects the performance of a critical application. The company needs to improve application performance with minimal costs.Which solution will meet these requirements with the LEAST operational overhead?

• A. Add functionality to the script to identify the instance that has the fewest active connections. Configure the script to read from that instance to report the total new entries.
• B. Create a read replica of the database. Configure the script to query only the read replica to report the total new entries. ✓
• C. Instruct the development team to manually export the new entries for the day in the database at the end of each day.
• D. Use Amazon ElastiCache to cache the common queries that the script runs against the database.

Correct Answer: B. Create a read replica of the database. Configure the script to query only the read replica to report the total new entries.

Explanation

To improve application performance with minimal operational overhead in a scenario where a script negatively affects the performance of a critical application that runs on an Amazon RDS database deployed to multiple Availability Zones, the most suitable solution is:B. Create a read replica of the database. Configure the script to query only the read replica to report the total new entries.Creating a read replica of the database allows for offloading read traffic from the primary database instance. By configuring the script to query only the read replica, you can isolate the impact of the script from the critical application running on the primary instance. This helps improve application performance without incurring additional operational overhead.Here's why the other options are not the most suitable choices:A. Adding functionality to the script to identify the instance with the fewest active connections: While this approach aims to distribute the load among the instances, it requires additional scripting and logic to determine the instance with the fewest active connections. It may introduce complexity and operational overhead.C. Instructing the development team to manually export the new entries for the day: This approach introduces manual intervention and requires the development team to perform a daily export of new entries. It not only adds operational overhead but also increases the risk of human error and delays in reporting.D. Using Amazon ElastiCache to cache common queries: Amazon ElastiCache is an in-memory caching service that is primarily designed for caching frequently accessed data to improve application performance. However, in this scenario, the script is reporting new entries, which implies write operations to the database. Caching common queries may not address the performance issue caused by the script and may not be the most appropriate solution.Therefore, the solution that meets the requirement of improving application performance with minimal operational overhead is:B. Create a read replica of the database. Configure the script to query only the read replica to report the total new entries.