DOP-C02 Monitoring and Logging Practice Question
A company uses Amazon RDS for MySQL. The database performance has degraded, and the engineer suspects that slow queries are the cause. Which service should be used to identify and analyze the slow queries?
⚠ Common exam trap
Test-takers frequently confuse CloudWatch Logs (which can store slow query logs) with a native analysis tool, overlooking that Performance Insights provides immediate, built-in visualization and query-level analysis without requiring custom log parsing.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Amazon RDS Performance Insights
Amazon RDS Performance Insights is the correct service because it provides a database-specific performance schema that visualizes database load and identifies the exact SQL queries causing performance degradation. It integrates directly with RDS for MySQL, offering a dashboard that breaks down wait events, SQL text, and host-level metrics, making it the ideal tool for analyzing slow queries.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Amazon RDS Performance Insights
Why this is correct
Amazon RDS Performance Insights is the correct choice because it provides a database-focused dashboard that visualizes the DB Load metric in units of Average Active Sessions (AAS), directly correlating temporal load spikes with the specific SQL statements, waits, hosts, and users responsible. This enables you to drill down into individual slow queries and diagnose performance degradation without needing to manually parse slow query logs or instrument application code.
- ✗
Amazon CloudWatch Metrics
Why it's wrong here
Amazon CloudWatch Metrics is incorrect because it exposes only aggregated, high-level RDS metrics such as CPUUtilization, DatabaseConnections, ReadIOPS, and FreeableMemory. These metrics can indicate that a performance problem exists, but they lack query-level detail and cannot show you which individual SQL statements or database waits are consuming resources, making them insufficient for pinpointing slow query root causes.
- ✗
Amazon CloudWatch Logs
Why it's wrong here
Amazon CloudWatch Logs captures and stores log data but lacks built-in query analysis for database-specific slow query patterns; the correct service, Performance Insights, provides a dashboard that visualises database load and identifies specific SQL queries causing performance degradation. CloudWatch Logs is tempting because it can ingest MySQL slow query logs if manually enabled, and would be correct for centralised log aggregation and alerting across multiple services.
- ✗
AWS X-Ray
Why it's wrong here
AWS X-Ray is incorrect because it is a distributed tracing tool that tracks request flows through application services, not a database performance monitoring service. While X-Ray can be manually instrumented to record SQL statements as subsegments, it does not automatically capture RDS MySQL database load, wait events, or query-level performance insights, so it cannot provide the built-in, DB-native slow query analysis needed here.
Go deeper
Related to this question
About these practice questions
This DOP-C02 question is part of Courseiva's 251-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DOP-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DOP-C02 exam.