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?

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).








 

Suggested Answer: B

Community Answer: A




This question is in DBS-C01 AWS Certified Database – Specialty Exam
For getting AWS Certified Database – Specialty Certificate


Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Amazon.
Trademarks, certification & product names are used for reference only and belong to Amazon.
The website does not contain actual questions and answers from Amazon's Certification Exam.