DBS-C01 Monitoring and Troubleshooting Practice Question
A company is experiencing slow query performance on an Amazon RDS for MySQL database. The DBA wants to identify the most time-consuming queries. Which TWO actions should the DBA take? (Choose two.)
⚠ Common exam trap
A common mix-up: candidates confuse general logging (Option B) with slow query logging, or assume Enhanced Monitoring (Option C) provides query-level insights, when in fact only Performance Insights and the slow query log directly identify the most time-consuming queries.
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
✓
Use Amazon RDS Performance Insights.
Amazon RDS Performance Insights (Option D) provides a database performance tuning and monitoring feature that visualizes database load and identifies the most time-consuming queries by breaking down wait events, SQL statements, and hosts. It directly helps the DBA pinpoint the specific queries causing performance degradation without additional configuration or overhead.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable the audit log.
Why it's wrong here
Audit log is for compliance, not performance.
- ✗
Enable the general log and review it.
Why it's wrong here
General log records all queries, not just slow ones.
- ✗
Use Amazon RDS Enhanced Monitoring.
Why it's wrong here
Enhanced Monitoring shows OS metrics, not query details.
- ✓
Use Amazon RDS Performance Insights.
Why this is correct
Performance Insights identifies top SQL by load.
- ✓
Enable the slow query log and monitor it in CloudWatch Logs.
Why this is correct
Slow query log captures queries that exceed a certain time.
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-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 DBS-C01 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 DBS-C01 exam.