An ecommerce company is migrating its core application database to Amazon Aurora MySQL. The company is currently performing online transaction processing
(OLTP) stress testing with concurrent database sessions. During the first round of tests, a database specialist noticed slow performance for some specific write operations.
Reviewing Amazon CloudWatch metrics for the Aurora DB cluster showed 90% CPU utilization.
Which steps should the database specialist take to MOST effectively identify the root cause of high CPU utilization and slow performance? (Choose two.)

A. Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.

B. Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I/O.

C. Review Amazon RDS Performance Insights to identify the top SQL statements and wait events.

D. Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.

E. Enable Advance Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.






 

Suggested Answer: BC

Community Answer: AC

Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.API.html

 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.