DOP-C02 Monitoring and Logging Practice Question
A company is using Amazon RDS for PostgreSQL and wants to monitor the database for performance issues. They need to capture slow queries and analyze them over time. Which combination of AWS services should they use?
⚠ Common exam trap
It's easy for candidates to confuse general monitoring (CloudWatch Metrics) or log export (CloudWatch Logs to S3) with the specialized, integrated performance analysis tools (Performance Insights and Enhanced Monitoring) that are purpose-built for diagnosing slow queries in RDS.
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
✓
Enable RDS Performance Insights and Enhanced Monitoring.
RDS Performance Insights provides a database performance schema with detailed wait events and SQL-level metrics to identify slow queries, while Enhanced Monitoring offers OS-level metrics (CPU, memory, disk I/O) at sub-minute granularity. Together, they allow you to capture and analyze slow queries over time without additional log parsing or export 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 RDS Event notifications to send alerts for performance issues.
Why it's wrong here
Amazon RDS Event notifications are designed to signal state transitions of the DB instance itself—such as failover, maintenance windows, backups, or configuration changes—by publishing SNS messages. They do not inspect, parse, or analyze SQL query performance or database load, so they cannot help identify or diagnose slow-running queries. Alerts about events like 'failover occurred' are useful for operational awareness, but they do not capture the query-level metrics needed for performance troubleshooting.
- ✓
Enable RDS Performance Insights and Enhanced Monitoring.
Why this is correct
RDS Performance Insights is the correct approach because it provides a database-load dashboard that correlates wait events, SQL statements, and hosts in real time, allowing you to pinpoint the exact queries causing bottlenecks. Enhanced Monitoring complements this by delivering OS-level metrics—including CPU, memory, file I/O, and process lists—from the underlying hypervisor, which helps identify resource saturation that affects query performance. Together, these services give both the query-level and system-level telemetry required to diagnose slow PostgreSQL performance.
- ✗
Enable CloudWatch Logs for PostgreSQL and export logs to Amazon S3.
Why it's wrong here
Enabling PostgreSQL logs in CloudWatch Logs and exporting them to Amazon S3 only addresses log collection and archival; it does not provide any analysis of slow queries or performance issues by itself. To derive insights, you would need to run additional tooling such as CloudWatch Logs Insights queries, pgBadger, or Athena on the S3 exports to parse and correlate query patterns. Without that downstream processing, the exported logs remain raw data and do not offer proactive or reactive performance diagnosis.
- ✗
Use CloudWatch Metrics to monitor database connections and CPU utilization.
Why it's wrong here
CloudWatch Metrics can track scaled indicators such as DatabaseConnections, CPUUtilization, and ReadIOPS, which give a high-level view of instance health. However, these metrics are aggregated and do not include any per-SQL query details, wait events, or slow query logs, so they cannot reveal which specific queries are inefficient or why. Metric alarms might indicate a symptom like high CPU, but they are insufficient for pinpointing the slow queries themselves.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DOP-C02 question from scratch — 1,298 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 →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DOP-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 DOP-C02 exam.