Which actions should the database professional take to determine the main cause of excessive CPU use and sluggish performance most effectively?

Amazon Aurora MySQL is being used by an ecommerce business to migrate its main

application database. The firm is now doing OLTP stress testing using concurrent database connections. A database professional detected sluggish performance for several particular write operations during the first round of testing.

Examining the Amazon CloudWatch stats for the Aurora DB cluster revealed a CPU usage of 90%.

Which actions should the database professional take to determine the main cause of excessive CPU use and sluggish performance most effectively? (Select 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.

View Answer

Answer: A,C

Explanation:

https://aws.amazon.com/premiumsupport/knowledge-center/rds-instance-high-cpu/

https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-slow-query/