DVA-C02 Troubleshooting and Optimization Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✓

  RDS Performance Insights

  Why this is correct

  RDS Performance Insights is specifically designed to help developers understand database load by visualizing active sessions and identifying the top SQL queries, hosts, or users consuming database resources. It provides a graphical dashboard that correlates database load with specific SQL statements, wait events, and user activity, making it ideal for pinpointing the exact queries or processes contributing to high CPU utilization on an RDS MySQL instance. This tool directly answers the need to identify *what* is causing the CPU spike, not just that a spike occurred.

• ✗

  RDS Enhanced Monitoring

  Why it's wrong here

  RDS Enhanced Monitoring provides granular operating system metrics for your RDS instance, including CPU utilization, memory, I/O, and process list information, delivered at a one-second granularity. While it shows *that* the CPU utilization is high, it does not inherently provide insights into the specific SQL queries or database events causing the CPU load. It's excellent for observing the *symptom* at the OS level but lacks the database-specific context needed to diagnose the *root cause* of performance issues related to database queries.

• ✗

  AWS X-Ray

  Why it's wrong here

  AWS X-Ray is a service primarily used for tracing end-to-end requests as they flow through distributed applications, helping developers analyze and debug production applications. While X-Ray can visualize calls to an RDS database as part of an application trace, it focuses on the latency of the database call *from the application's perspective* and does not provide internal database performance metrics or query-level analysis within the RDS instance itself. It's an application-centric tool, not a database-centric performance diagnostic tool.

• ✗

  CloudWatch Logs Insights

  Why it's wrong here

  CloudWatch Logs Insights is a powerful interactive query service designed for analyzing log data stored in CloudWatch Logs, allowing users to search, filter, and aggregate log entries. While you could potentially ingest RDS slow query logs or general logs into CloudWatch Logs and then use Logs Insights to analyze them, it is not a dedicated, real-time database performance monitoring solution. It requires manual log parsing and query construction, lacking the integrated, graphical, and real-time active session and wait event analysis that Performance Insights offers for immediate database performance diagnostics.

Go deeper

Related to this question