SAA-C03 · Question #133
A company hosts a database that runs on an Amazon RDS instance deployed to multiple Availability Zones. A periodic script negatively affects a critical application by querying the database. How can…
The correct answer is B. Create a read replica of the database. Configure the script to query only the read replica. Option A introduces complexity and does not scale well. Option B creates a read replica, offloading read traffic from the primary RDS instance without impacting the critical application. Option C is manual and inefficient. Option D might help for caching frequently queried data…
Question
A company hosts a database that runs on an Amazon RDS instance deployed to multiple Availability Zones. A periodic script negatively affects a critical application by querying the database. How can application performance be improved with minimal costs?
Options
- AAdd functionality to the script to identify the instance with the fewest active connections and query
- BCreate a read replica of the database. Configure the script to query only the read replica.
- CInstruct the development team to manually export new entries at the end of the day.
- DUse Amazon ElastiCache to cache the common queries the script runs.
How the community answered
(57 responses)- A9% (5)
- B84% (48)
- C4% (2)
- D4% (2)
Explanation
Option A introduces complexity and does not scale well. Option B creates a read replica, offloading read traffic from the primary RDS instance without impacting the critical application. Option C is manual and inefficient. Option D might help for caching frequently queried data but is not ideal for ad-hoc reporting. Therefore, Option B is the best choice.
Community Discussion
No community discussion yet for this question.