DBS-C01 · Question #110
DBS-C01 Question #110: Real Exam Question with Answer & Explanation
The correct answer is C: Modify applications to commit transactions in batches.. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Referenc https://blog.dbi-services.com/aws-aurora-xactsync-batch-commit/
Question
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?
Options
- AAdd an Aurora Replica to scale the read traffic.
- BScale up the DB instance class.
- CModify applications to commit transactions in batches.
- DModify applications to avoid conflicts by taking locks.
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Referenc https://blog.dbi-services.com/aws-aurora-xactsync-batch-commit/
Topics
Community Discussion
No community discussion yet for this question.