SAP-C02 Continuous Improvement for Existing Solutions Practice Question

A company uses Amazon RDS for MySQL for its database. The operations team notices that read queries are slow during peak hours. The application is read-heavy and can tolerate eventual consistency. Which solution would improve read performance with minimal application changes?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Create an RDS read replica and direct read traffic to it.

Creating an RDS read replica allows read traffic to be offloaded from the primary DB instance, significantly improving read performance with minimal application changes, and the application can tolerate eventual consistency. Option A is incorrect because increasing the DB instance class may help but is more costly and does not scale reads independently. Option B is incorrect because Multi-AZ provides high availability and failover, not read scaling. Option C is incorrect because RDS Proxy is for connection pooling and managing database connections, not for scaling reads.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Increase the DB instance class to a larger size.
Why it's wrong here
Scaling up helps but is not the most cost-effective solution for read-heavy workloads.
✗
Enable Multi-AZ deployment for failover support.
Why it's wrong here
Multi-AZ does not improve read performance.
✗
Enable RDS Proxy to pool database connections.
Why it's wrong here
RDS Proxy improves connection efficiency, not read throughput.
✓
Create an RDS read replica and direct read traffic to it.
Why this is correct
Read replicas offload read queries and can be added without application changes.

Go deeper

SAP-C02 Continuous Improvement for Existing Solutions Practice Question

Why each option matters

Option-by-option breakdown

Related to this question