Amazon AWS Certified Database - Specialty
Prev

There are 231 results

Next
#231 (Accuracy: 100% / 5 votes)
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).