DBS-C01 Deployment and Migration Practice Question
A company is migrating a 3 TB SQL Server database to Amazon RDS for SQL Server. The migration must have minimal downtime and support point-in-time recovery after migration. Which THREE steps should be included in the migration plan? (Choose three.)
⚠ Common exam trap
Watch out — candidates often confuse snapshot backups (which are not supported for native restore in RDS) with full backups, or think a differential backup can be used as the initial restore point without a preceding full backup.
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
✓
Take a full backup of the source database.
A full backup is the foundational step for any SQL Server migration to Amazon RDS. It captures the complete database state at a point in time, which is required for the initial restore into RDS. Without a full backup, you cannot apply differential or transaction log backups to achieve minimal downtime and point-in-time recovery.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Take a snapshot backup of the source database.
Why it's wrong here
RDS does not support restoring from native snapshots.
- ✗
Take a differential backup.
Why it's wrong here
Not necessary if using transaction log backups.
- ✓
Take a full backup of the source database.
Why this is correct
Required for initial restore.
- ✓
Use AWS DMS for ongoing replication after initial restore.
Why this is correct
Minimizes downtime by replicating changes.
- ✓
Take transaction log backups.
Why this is correct
Allow point-in-time recovery and minimize data loss.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 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 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.