DBS-C01 Deployment and Migration Practice Question
A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and support ongoing replication. Which combination of AWS services should they use?
⚠ Common exam trap
A common mix-up: candidates assume AWS DMS alone is sufficient for any migration, forgetting that schema conversion (via AWS SCT) is critical when moving to a different SQL Server version or when source objects are incompatible with RDS, which the exam tests as a required combination for minimizing downtime and supporting ongoing 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
✓
AWS SCT and AWS DMS
AWS DMS (Database Migration Service) can perform a full load of the 1 TB SQL Server database and then continuously replicate ongoing changes using change data capture (CDC) to minimize downtime. AWS SCT (Schema Conversion Tool) is used to assess and convert any incompatible schema objects (e.g., stored procedures, indexes) from the source SQL Server to the target RDS for SQL Server, ensuring a smooth migration. Together, they provide a complete solution for heterogeneous or homogeneous migration with minimal downtime and ongoing replication.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
AWS SCT and AWS DMS
Why this is correct
SCT converts schema, DMS migrates data with ongoing replication.
- ✗
AWS S3 and AWS Glue
Why it's wrong here
Glue is for ETL, not for live database replication.
- ✗
AWS DMS alone
Why it's wrong here
DMS can migrate data but may not handle schema conversion automatically.
- ✗
Native SQL Server backup and restore to RDS
Why it's wrong here
Backup/restore is a one-time operation, no ongoing replication.
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.