SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is migrating a 10 TB Oracle database to Amazon Aurora PostgreSQL. The database is business-critical and must have minimal downtime. The company has set up AWS DMS with ongoing replication from the source. During the migration, the company notices that DMS is failing with an error indicating insufficient memory. What should the company do to resolve this issue and complete the migration?
⚠ Common exam trap
Many candidates think the error is on the source database (Option A) or that splitting tasks (Option D) solves memory issues, but DMS's memory error is specific to the replication instance's capacity, not the source or task granularity.
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 instance class of the DMS replication instance
AWS DMS replication instances have finite memory allocated to cache changes during ongoing replication (CDC). When the volume of cached changes exceeds the instance's memory, DMS fails with an insufficient memory error. Increasing the instance class of the DMS replication instance (Option B) provides more memory to handle the cache, resolving the error without disrupting the migration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase the memory on the source Oracle database
Why it's wrong here
The error is on the DMS replication instance, not the source database.
- ✓
Increase the instance class of the DMS replication instance
Why this is correct
DMS replication instance memory is insufficient; upgrading the instance class resolves the issue.
- ✗
Change the DMS task to use change data capture (CDC) only and skip the full load
Why it's wrong here
CDC only will not migrate existing data; a full load is needed.
- ✗
Split the migration into multiple smaller tasks
Why it's wrong here
Splitting would require starting over and may increase total downtime.
Visual reference
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.