Amazon Exam DBS-C01 Topic 9 Question 32 Discussion

Actual exam question for Amazon's DBS-C01 exam

Question #: 32
Topic #: 9

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?

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.

Show Suggested Answer

Suggested Answer: A

by Venita at May 05, 2022, 04:37 AM

Limited Time Offer

25%

Off

Get Premium DBS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!