AWS Certified Database – Specialty — Question 83

A large retail company recently migrated its three-tier ecommerce applications to AWS. The company's backend database is hosted on Amazon Aurora
PostgreSQL. During peak times, users complain about longer page load times. A database specialist reviewed Amazon RDS Performance Insights and found a spike in IO:XactSync wait events. The SQL attached to the wait events are all single INSERT statements.
How should this issue be resolved?

Answer options

• A. Modify the application to commit transactions in batches
• B. Add a new Aurora Replica to the Aurora DB cluster.
• C. Add an Amazon ElastiCache for Redis cluster and change the application to write through.
• D. Change the Aurora DB cluster storage to Provisioned IOPS (PIOPS).

Correct answer: A

Explanation

The correct answer is A because modifying the application to commit transactions in batches can significantly reduce the number of IO:XactSync wait events, thereby improving performance during peak times. Options B, C, and D may enhance overall performance or scalability but do not directly address the specific issue of single INSERT statements causing the wait events.