DBS-C01 Deployment and Migration Practice Question
Which TWO steps are required when migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server using AWS DMS with ongoing replication?
⚠ Common exam trap
Many candidates confuse MS-CDC with MS-Replication, assuming DMS requires replication agents or topology, when in fact DMS uses native CDC or log-based capture without setting up replication.
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
✓
Enable MS-CDC (change data capture) on the source database.
AWS DMS requires MS-CDC (change data capture) to be enabled on the source SQL Server database when using ongoing replication (change data capture). CDC captures insert, update, and delete activity from the transaction log, allowing DMS to apply those changes to the target RDS for SQL Server instance without requiring full table reloads.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Create a VPC peering connection between the on-premises network and the DMS VPC.
Why it's wrong here
VPC peering is for VPC-to-VPC; for on-premises, use VPN or Direct Connect.
- ✗
Install the DMS agent on the source SQL Server instance.
Why it's wrong here
DMS uses a replication instance in AWS, not an agent on the source.
- ✓
Enable MS-CDC (change data capture) on the source database.
Why this is correct
DMS uses CDC to capture ongoing changes from SQL Server.
- ✗
Configure MS-Replication on the source database.
Why it's wrong here
DMS does not use MS-Replication; it uses native CDC capabilities.
- ✓
Ensure the source database is using the full recovery model.
Why this is correct
Full recovery model is needed to capture all transactions for ongoing replication.
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.