SAP-C02 Continuous Improvement for Existing Solutions Practice Question
A company runs a critical database on Amazon RDS for PostgreSQL. The database is experiencing performance degradation due to high CPU utilization. The operations team wants to analyze the root cause. Which THREE steps should the team take to diagnose the issue?
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 Enhanced Monitoring to view OS-level metrics such as CPU and memory usage.
Options A, C, and D are correct. Enabling Enhanced Monitoring provides OS-level metrics like CPU and memory usage, helping to identify resource bottlenecks. Performance Insights helps identify the specific queries consuming the most CPU, enabling targeted optimization. Reviewing RDS events can reveal recent maintenance activities or failovers that might impact performance. Option B is incorrect because increasing instance size or IOPS is a remedial action, not a diagnostic step. Option E is incorrect because Multi-AZ is for high availability, not performance diagnosis.
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 Enhanced Monitoring to view OS-level metrics such as CPU and memory usage.
Why this is correct
Enhanced Monitoring provides detailed OS metrics.
- ✗
Increase the instance size to provisioned IOPS to handle the load.
Why it's wrong here
This is a remedial action, not a diagnostic step.
- ✓
Enable Amazon RDS Performance Insights to identify the queries consuming the most CPU.
Why this is correct
Performance Insights provides database performance analysis.
- ✓
Review Amazon RDS events to check for any recent maintenance or failover activities.
Why this is correct
RDS events can reveal underlying causes like patching.
- ✗
Enable Multi-AZ deployment for automatic failover.
Why it's wrong here
Multi-AZ improves availability, not performance diagnosis.
Go deeper
Related to this question
About these practice questions
This SAP-C02 question is part of Courseiva's 1,660-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 SAP-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 SAP-C02 exam.