AWS Certified Solutions Architect – Associate (SAA-C02) — Question 312

A company has multiple applications that use Amazon RDS for MySQL as is database. The company recently discovered that a new custom reporting application has increased the number of Queries on the database. This is slowing down performance.
How should a solutions architect resolve this issue with the LEAST amount of application changes?

Answer options

• A. Add a secondary DB instance using Multi-AZ.
• B. Set up a road replica and Multi-AZ on Amazon RDS.
• C. Set up a standby replica and Multi-AZ on Amazon RDS.
• D. Use caching on Amazon RDS to improve the overall performance.

Correct answer: B

Explanation

To offload read-heavy reporting queries from the primary database instance with minimal code changes, setting up an Amazon RDS read replica is the ideal solution. While Multi-AZ deployments provide high availability, the standby replica cannot accept active read traffic, making a read replica necessary to handle the reporting workload. Caching is not a native RDS feature that can be easily implemented without significant application-level changes.