A company is using Amazon Aurora PostgreSQL for the backend of its application. The system users are complaining that the responses are slow. A database specialist has determined that the queries to Aurora take longer during peak times. With the Amazon RDS Performance Insights dashboard, the load in the chart for average active sessions is often above the line that denotes maximum CPU usage and the wait state shows that most wait events are IO:XactSync. What should the company do to resolve these performance issues?
A) Add an Aurora Replica to scale the read traffic.
B) Scale up the DB instance class.
C) Modify applications to commit transactions in batches.
D) Modify applications to avoid conflicts by taking locks.

Question

Quizplus · Accepted Answer

Adding an Aurora Replica can help scale the read traffic and reduce the load on the primary instance, potentially improving query response times during peak times.

A Company Is Using Amazon Aurora PostgreSQL for the Backend