nerdexam
AmazonAmazon

DBS-C01 · Question #122

DBS-C01 Question #122: Real Exam Question with Answer & Explanation

Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #122. The question stem and answer options stay visible for context.

Submitted by sofia.br· Mar 6, 2026Monitoring and Troubleshooting

Question

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?

Options

  • AModify the application to commit transactions in batches
  • BAdd a new Aurora Replica to the Aurora DB cluster.
  • CAdd an Amazon ElastiCache for Redis cluster and change the application to write through.
  • DChange the Aurora DB cluster storage to Provisioned IOPS (PIOPS).

Unlock DBS-C01 to see the answer

You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Aurora PostgreSQL#Performance Insights#IO:XactSync#transaction optimization#batch processing#performance tuning
Full DBS-C01 PracticeBrowse All DBS-C01 Questions