SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is migrating a 5 TB Microsoft SQL Server database to Amazon RDS for SQL Server. The migration must have minimal downtime. The team uses AWS DMS with ongoing replication. During the full load, the task fails with an error indicating that the source server's transaction log is full. What should the team do to resolve this issue?
⚠ Common exam trap
Many exam-takers confuse the transaction log full error with a performance issue, leading them to choose options like resizing the instance or changing apply mode, rather than addressing the log space directly.
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 source server's transaction log size and set the log retention to a higher value.
The error indicates the source transaction log is full during the full load phase of AWS DMS. Increasing the transaction log size and setting a higher log retention value prevents the log from filling up while DMS reads it for ongoing replication. This allows the full load to complete without interruption, addressing the root cause directly.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Stop the DMS task, take a native backup of the source, restore it to RDS, and then start DMS with ongoing replication.
Why it's wrong here
This adds complexity and may lose changes during backup/restore.
- ✓
Increase the source server's transaction log size and set the log retention to a higher value.
Why this is correct
This gives DMS more time to capture changes without filling the log.
- ✗
Pause the DMS task, create a larger source instance, and restart the task.
Why it's wrong here
Larger instance may not solve log full issue; DMS still needs log space.
- ✗
Switch the DMS task to use batch-optimized apply mode.
Why it's wrong here
Batch-optimized applies changes in batches; doesn't affect log capture.
Visual reference
Go deeper
Related to this question
About these practice questions
One of 1,660 original SAP-C02 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.