SAP-C02 Continuous Improvement for Existing Solutions Practice Question
A company runs a production database on Amazon RDS for PostgreSQL. The database experiences high write latency during peak hours. The company wants to improve write performance with minimal cost. Which action should a solutions architect take?
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
✓
Increase the allocated storage and provisioned IOPS.
To improve write performance, increasing allocated storage and provisioned IOPS can reduce write latency by providing more I/O capacity. While other options like sharding could theoretically help, Option C is not feasible because Amazon RDS for PostgreSQL does not support multiple write replicas; only read replicas are available. Option D is the most practical and cost-effective solution among the given choices.
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 Multi-AZ deployment for automatic failover.
Why it's wrong here
Multi-AZ deployment provides high availability and automatic failover, but does not improve write performance.
- ✗
Add multiple read replicas in different Availability Zones.
Why it's wrong here
Read replicas handle read traffic, not write operations, so they do not reduce write latency.
- ✗
Use RDS for PostgreSQL with multiple write replicas and configure application-level sharding.
Why it's wrong here
RDS for PostgreSQL does not support multiple write replicas; only read replicas are available. Therefore, this approach is not achievable.
- ✓
Increase the allocated storage and provisioned IOPS.
Why this is correct
Increasing allocated storage and provisioned IOPS directly improves I/O capacity, reducing write latency. It is a viable and cost-effective solution for high write loads.
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.