DBS-C01 Monitoring and Troubleshooting Practice Question
A company is running a production Amazon RDS for PostgreSQL database. The database has experienced a sudden spike in CPU utilization, causing application timeouts. The monitoring team needs to identify the root cause. Which AWS service or feature should be used to analyze the database load and identify the specific queries causing the high CPU?
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 correct because it provides a database performance tuning and monitoring feature that helps quickly assess the load on your database and identify specific queries causing high CPU utilization. Option A (Enhanced Monitoring) is wrong because it provides OS-level metrics, not database query details. Option B (Amazon CloudWatch Logs) is wrong because it captures database logs, not real-time performance data. Option D (AWS Trusted Advisor) is wrong because it provides best practice checks but not query-level analysis.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enhanced Monitoring
Why it's wrong here
Enhanced Monitoring provides OS-level metrics (CPU, memory, etc.) but does not identify specific queries causing high CPU.
- ✗
Amazon CloudWatch Logs
Why it's wrong here
CloudWatch Logs captures database logs (error logs, slow query logs) but does not provide real-time performance data or query-level load analysis.
- ✓
Amazon RDS Performance Insights
Why this is correct
Performance Insights offers a database performance tuning feature that visualizes database load and identifies the specific SQL queries causing high CPU utilization.
- ✗
AWS Trusted Advisor
Why it's wrong here
AWS Trusted Advisor checks for best practices and cost optimization but does not provide query-level analysis or performance tuning.
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.