DBS-C01 Monitoring and Troubleshooting Practice Question
A database specialist is troubleshooting a slow Amazon RDS for PostgreSQL query. The specialist has enabled Performance Insights and sees that the database load is high. Which additional tool can provide detailed information about the specific queries causing the load?
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 Enhanced Monitoring to view OS-level metrics and correlate with performance insights.
Enhanced Monitoring provides OS-level metrics (CPU, memory, disk I/O, etc.), which when combined with Performance Insights' query-level details, gives a comprehensive view of database performance. Option A is wrong because VPC Flow Logs capture network traffic information, not query-specific details. Option B is wrong because CloudWatch Logs can analyze PostgreSQL error logs, but this does not provide detailed query-level load information. Option D is wrong because AWS CloudTrail records API calls, not database 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.
- ✗
Use VPC Flow Logs to analyze network traffic to the database.
Why it's wrong here
VPC Flow Logs are for network traffic, not query performance.
- ✗
Use Amazon CloudWatch Logs to analyze the PostgreSQL error logs.
Why it's wrong here
Error logs may not show query performance details.
- ✓
Use Enhanced Monitoring to view OS-level metrics and correlate with performance insights.
Why this is correct
Enhanced Monitoring provides OS metrics that help diagnose resource contention.
- ✗
Use AWS CloudTrail to view database API calls.
Why it's wrong here
CloudTrail is for API calls, not query performance.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.