DBS-C01 Deployment and Migration Practice Question
A company is migrating a 10 TB Oracle data warehouse to Amazon Redshift. They want to use AWS DMS for continuous replication. However, the migration is taking longer than expected due to LOB columns. What optimization should be applied?
⚠ Common exam trap
Candidates often assume FullLobMode is always the safest or fastest choice, not realizing that its per-LOB API call overhead is the very cause of the slowdown, while LimitedLobMode with a properly tuned MaxLobSize dramatically improves throughput for LOB columns.
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
✓
Set MaxLobSize to a value like 64 KB to limit inline LOB transfer.
Setting MaxLobSize to a value like 64 KB instructs AWS DMS to treat LOBs smaller than that threshold as inline data, which is transferred more efficiently in the batch stream. This avoids the performance penalty of using FullLobMode, which transfers each LOB individually and can dramatically slow down continuous replication for large tables with many LOB columns.
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 AWS SCT to compress LOBs.
Why it's wrong here
SCT doesn't compress.
- ✗
Enable FullLobMode to transfer all LOBs.
Why it's wrong here
FullLobMode is slower.
- ✓
Set MaxLobSize to a value like 64 KB to limit inline LOB transfer.
Why this is correct
This optimizes performance.
- ✗
Increase the number of DMS tasks.
Why it's wrong here
May not address LOB issue directly.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DBS-C01 question from scratch — 1,663 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 DBS-C01 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 DBS-C01 exam.