SAP-C02 Continuous Improvement for Existing Solutions Practice Question
A company uses Amazon RDS for PostgreSQL with Multi-AZ and automated backups set to 35 days. The database experiences a sudden spike in write IOPS, causing performance degradation. The team needs to investigate the cause without affecting production. What should they do?
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
✓
Create a read replica from the latest automated snapshot and enable Performance Insights on the replica.
Creating a read replica from the latest automated snapshot provides a near-current copy of the database without impacting the production instance. This allows the team to enable Performance Insights on the replica to analyze query performance and investigate the write IOPS spike safely. Option A is wrong because enhanced monitoring provides OS-level metrics but not query-level details needed for this investigation. Option B is wrong because CloudWatch metrics show overall performance but not individual queries. Option C is wrong because enabling Performance Insights on the production instance could add overhead and impact performance.
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 the enhanced monitoring feature to collect OS-level metrics on the production instance.
Why it's wrong here
Enhanced monitoring does not provide query-level details.
- ✗
Review Amazon CloudWatch metrics for the production DB instance to identify the cause.
Why it's wrong here
CloudWatch metrics are aggregate and insufficient for pinpointing queries.
- ✗
Enable Performance Insights on the production instance to analyze queries.
Why it's wrong here
Performance Insights adds minor overhead, but better to use a replica.
- ✓
Create a read replica from the latest automated snapshot and enable Performance Insights on the replica.
Why this is correct
This provides a copy for analysis without impacting production.
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.