A SysOps administrator is troubleshooting performance on an Amazon RDS for MariaDB instance and needs to view database load broken down by detailed wait events. Which approach provides that level of insight?
Choose an answer
Tap an option to check your answer.
Correct answer: Enable Amazon RDS Performance Insights..
Why this is the answer
Enabling Amazon RDS Performance Insights is the correct approach because it specifically provides a visual dashboard that breaks down database load by detailed wait events, SQL queries, hosts, and users. This granular view is essential for identifying performance bottlenecks. Building a custom CloudWatch dashboard could show general metrics but lacks the deep, pre-analyzed wait event data Performance Insights offers. Enhanced Monitoring provides OS-level metrics, which are useful but don't detail database wait events or SQL queries. Inspecting database logs in CloudWatch Logs would be a manual and time-consuming process to extract and analyze wait event data, unlike the automated visualization provided by Performance Insights.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed