Quick Answer
The correct answer is to use RDS Performance Insights with database load and wait events and Amazon RDS Enhanced Monitoring together. This combination works because Performance Insights visualizes database load and surfaces the specific query text along with wait events like IO:DataFileRead, directly linking high I/O to a problematic statement, while Enhanced Monitoring provides OS-level metrics such as read/write IOPS and queue depth to confirm the I/O impact at the instance level. On the AWS Certified SysOps Administrator Associate SOA-C02 exam, this scenario tests your ability to correlate database-level and OS-level metrics for root cause analysis—a common trap is relying solely on CloudWatch metrics, which lack query-level granularity. Remember the pairing: Performance Insights shows you the “who” (the query and its wait event), and Enhanced Monitoring shows you the “what” (the I/O resource pressure). A useful memory tip is “PE” for Performance and Enhanced—together they pinpoint the query and its I/O footprint.
This SOA-C02 practice question tests your understanding of monitoring, logging, and remediation. The scenario asks you to isolate a root cause — eliminate options that address a different problem before choosing. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A SysOps administrator is troubleshooting a slow-running Amazon RDS for PostgreSQL instance. The administrator suspects that a specific query is causing high I/O. Which tools should be used together to identify the query and its I/O impact? (Choose THREE.)
Amazon RDS Performance Insights
Shows top SQL queries and their load.
Amazon CloudWatch Logs
Why wrong: Used for log files, not performance analysis.
AWS CloudTrail
Why wrong: Records API calls, not database performance.
Amazon RDS Enhanced Monitoring
Provides OS-level metrics including disk I/O.
RDS Performance Insights with database load and wait events
Identifies I/O waits for specific queries.
Answer choices
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 (A) provides a database performance dashboard that visualizes database load and identifies the specific queries causing high load, including I/O wait events. By correlating this with Amazon RDS Enhanced Monitoring (D), which offers OS-level metrics like read/write IOPS and queue depth, you can pinpoint the exact query and its I/O impact. The combination of RDS Performance Insights with database load and wait events (E) directly surfaces the query text and the wait types (e.g., IO:DataFileRead) to confirm high I/O.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Amazon RDS Performance Insights
Why this is correct
Shows top SQL queries and their load.
Related concept
Read the scenario before looking for a memorised answer.
Amazon CloudWatch Logs
Why it's wrong here
Used for log files, not performance analysis.
AWS CloudTrail
Why it's wrong here
Records API calls, not database performance.
Amazon RDS Enhanced Monitoring
Why this is correct
Provides OS-level metrics including disk I/O.
Related concept
Read the scenario before looking for a memorised answer.
RDS Performance Insights with database load and wait events
Why this is correct
Identifies I/O waits for specific queries.
Related concept
Read the scenario before looking for a memorised answer.
Common exam traps
The trap here is that candidates might select CloudWatch Logs or CloudTrail thinking they can capture query logs or API calls to diagnose performance, but neither provides the real-time database load breakdown or OS-level I/O metrics needed to identify the specific query and its I/O impact.
Detailed technical explanation
RDS Performance Insights uses a 'database load' metric measured in Average Active Sessions (AAS), which breaks down by wait events (e.g., IO:DataFileRead, IO:WALWrite) to isolate I/O-bound queries. Enhanced Monitoring provides hypervisor-level metrics at 1-second granularity, such as disk queue depth and read/write latency, which correlate with the wait events seen in Performance Insights. In a real-world scenario, a missing index on a large table scan would show high AAS for IO:DataFileRead in Performance Insights and elevated write IOPS in Enhanced Monitoring.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Monitoring, Logging, and Remediation — study guide chapter
Learn the concepts, then practise the questions
Monitoring, Logging, and Remediation practice questions
Targeted practice on this topic area only
All SOA-C02 questions
1,546 questions across all exam domains
AWS Certified SysOps Administrator Associate SOA-C02 study guide
Full concept coverage aligned to exam objectives
SOA-C02 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise SOA-C02 questions linked to Monitoring, Logging, and Remediation.
Practise SOA-C02 questions linked to Reliability and Business Continuity.
Practise SOA-C02 questions linked to Deployment, Provisioning, and Automation.
Practise SOA-C02 questions linked to Security and Compliance.
Practise SOA-C02 questions linked to Networking and Content Delivery.
Practise SOA-C02 questions linked to Cost and Performance Optimization.
Practise SOA-C02 questions linked to SOA-C02 fundamentals.
Practise SOA-C02 questions linked to SOA-C02 scenario.
Practise SOA-C02 questions linked to SOA-C02 troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Monitoring, Logging, and Remediation — This question tests Monitoring, Logging, and Remediation — Read the scenario before looking for a memorised answer..
The correct answer is: Amazon RDS Performance Insights — Amazon RDS Performance Insights (A) provides a database performance dashboard that visualizes database load and identifies the specific queries causing high load, including I/O wait events. By correlating this with Amazon RDS Enhanced Monitoring (D), which offers OS-level metrics like read/write IOPS and queue depth, you can pinpoint the exact query and its I/O impact. The combination of RDS Performance Insights with database load and wait events (E) directly surfaces the query text and the wait types (e.g., IO:DataFileRead) to confirm high I/O.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A SysOps administrator notices that an Amazon RDS for MySQL instance's CPU utilization is consistently above 80% during business hours. The administrator wants to identify the queries causing the high load without impacting performance. Which action should be taken?
hardWhy B: Performance Insights provides a database-specific performance schema that visualizes database load and identifies the SQL queries responsible for high CPU utilization. It operates with minimal overhead by sampling the database engine's internal performance data, making it ideal for diagnosing query performance issues without impacting the production workload.
Variation 2. A SysOps administrator is investigating a performance issue with an Amazon RDS for PostgreSQL instance. The administrator has enabled Performance Insights. Which TWO metrics from Performance Insights can help identify the root cause of a sudden increase in database load? (Choose TWO.)
mediumWhy C: Performance Insights measures database load in units of Average Active Sessions (AAS). The 'DB Load by Wait Events' metric breaks down this load by the specific wait events (e.g., I/O, locks, CPU) that are causing sessions to wait, directly pinpointing the bottleneck. This is the primary diagnostic view for identifying the root cause of a sudden load increase.
Keep practising
Last reviewed: Jun 24, 2026
This SOA-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 SOA-C02 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.