Courseiva
← DVA-C02
Full test
Troubleshooting and Optimization →easyMultiple Choice

DVA-C02 Troubleshooting and Optimization Practice Question

A developer is troubleshooting a slow Amazon RDS MySQL database query. The query is frequently executed and takes 5 seconds to complete. Which AWS service should the developer use to analyze the query performance?

⚠ Common exam trap

DVA-C02 often tests the confusion between monitoring services like CloudWatch and specialized database performance tools like Performance Insights, leading candidates to choose CloudWatch Logs for query analysis.

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 to analyze query performance on an RDS MySQL database. It provides a dashboard that visualizes database load and helps identify the top SQL statements, wait events, and users consuming the most resources. This allows the developer to pinpoint the slow query and understand its impact.

Answer analysis

Option-by-option breakdown

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

  • ✗

    AWS CloudTrail

    Why it's wrong here

    CloudTrail is an API activity and governance audit log — it records who called which API, when, and from where, but it has no visibility into SQL execution plans, wait events, or query latency inside the database engine itself, so it cannot diagnose a slow query.

  • ✓

    Amazon RDS Performance Insights

    Why this is correct

    Performance Insights is purpose-built for this scenario: it visualizes database load as Average Active Sessions, breaks load down by SQL statement, wait event, host, and user, and lets the developer pinpoint exactly which query is consuming the most database time and why.

  • ✗

    Amazon CloudWatch Logs

    Why it's wrong here

    CloudWatch Logs can capture the MySQL slow query log or error log if log exports are enabled, but it only stores raw text entries without the aggregated wait-event analysis, execution counts, or top-SQL ranking that query-level performance tuning requires.

  • ✗

    AWS X-Ray

    Why it's wrong here

    X-Ray instruments application code to trace requests as they hop across services like API Gateway, Lambda, and downstream calls, showing latency per segment; it does not instrument the RDS engine internals or expose SQL-level performance metrics.

About these practice questions

Courseiva writes every DVA-C02 question from scratch — 1,135 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written and reviewed by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

Last reviewed September 2026 · checked against the official Amazon Web Services exam blueprint

This DVA-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 DVA-C02 exam.