AWS Certified Database – Specialty — Question 27

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation.
How can the Database Specialists accomplish this?

Answer options

• A. Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
• B. Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
• C. Enable Amazon RDS Performance Insights and review the appropriate dashboard
• D. Enable Enhanced Monitoring will the appropriate settings

Correct answer: C

Explanation

The correct answer is C because enabling Amazon RDS Performance Insights allows the team to view detailed metrics and wait events, which are crucial for diagnosing performance issues. Options A and B do not specifically target the analysis of wait events, while D, though useful, does not provide the specialized insights offered by Performance Insights.