SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is modernizing its application by migrating from a monolithic architecture to microservices on Amazon ECS Fargate. The application uses an on-premises Oracle database, which is being migrated to Amazon Aurora PostgreSQL as part of the modernization. The team has refactored the application into several microservices, each with its own database schema in the same Aurora cluster. During load testing, the team notices that one microservice's heavy write operations cause increased latency for other microservices' read queries. The Aurora cluster uses a single writer and multiple readers. The team needs to isolate the write-heavy microservice without changing the application code. What should the solutions architect 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 separate Aurora cluster for the write-heavy microservice and point the microservice to that cluster.
Using a separate Aurora cluster for the write-heavy microservice physically isolates the workload, preventing impact on other microservices. The application code points to different cluster endpoints. Using a larger instance might help but does not isolate; read replicas do not help with write contention; RDS Proxy is for connection pooling, not isolation.
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 Amazon RDS Proxy to manage database connections.
Why it's wrong here
RDS Proxy helps with connection management but does not isolate workloads.
- ✓
Create a separate Aurora cluster for the write-heavy microservice and point the microservice to that cluster.
Why this is correct
A separate cluster provides complete isolation of write operations.
- ✗
Configure Aurora read replicas to offload read queries from the writer.
Why it's wrong here
Read replicas only handle read traffic; write contention on the writer remains.
- ✗
Increase the instance size of the Aurora writer to handle the write load.
Why it's wrong here
Scaling up may reduce latency but does not isolate the write-heavy microservice; other queries may still be affected.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SAP-C02 question from scratch — 1,660 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 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.