DBS-C01 Deployment and Migration Practice Question
A company is migrating a self-hosted MongoDB database to Amazon DocumentDB. They need to ensure that indexes are created after the data load to improve migration performance. Which migration strategy should they use?
⚠ Common exam trap
Watch out — candidates often assume DMS has a built-in option to defer index creation (like some relational database migration tools), but DMS for DocumentDB requires manually configuring LOB handling and creating indexes post-load, and they might confuse the 'create indexes before data load' misconception with a real DMS feature.
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
✓
Use AWS Database Migration Service (DMS) with the 'lob' mode set to 'Don't include LOB columns' and create indexes after the full load.
AWS DMS can be configured to skip LOB columns during the full load, which significantly improves migration performance by reducing data transfer overhead. After the full load completes, indexes can be created on the target DocumentDB database, avoiding the performance penalty of maintaining indexes during the bulk data ingestion. This approach aligns with the requirement to defer index creation until after the data load.
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 Schema Conversion Tool (SCT) to convert the schema and then load data with DMS.
Why it's wrong here
SCT is not needed for MongoDB to DocumentDB migration; DocumentDB uses the same API.
- ✗
Use AWS DMS with 'create indexes before data load' option enabled.
Why it's wrong here
Creating indexes before load slows down migration because indexes are updated during data load.
- ✓
Use AWS Database Migration Service (DMS) with the 'lob' mode set to 'Don't include LOB columns' and create indexes after the full load.
Why this is correct
Deferring index creation speeds up data migration; DMS can handle data transfer.
- ✗
Use mongodump and mongorestore with the --writeConcern option set to 0.
Why it's wrong here
mongodump/mongorestore does not allow deferred index creation; indexes are created during restore.
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-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 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.