DBS-C01 Deployment and Migration Practice Question
A company is migrating a 1 TB SQL Server database from on-premises to Amazon RDS for SQL Server. The database has a large table with a LOB column. The network bandwidth between the on-premises data center and AWS is limited to 50 Mbps. The migration must be completed within a week. Which approach should the company use?
⚠ Common exam trap
Candidates often assume native backup and restore is universally supported for RDS migrations, but RDS for SQL Server restricts this to specific versions and requires the backup file to be uploaded to S3 first, which still faces bandwidth limitations without compression.
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 DMS with compression enabled.
AWS DMS with compression enabled is the correct approach because it can migrate the 1 TB database within the limited 50 Mbps bandwidth by compressing data during transfer, reducing the total data volume. DMS supports ongoing replication and handles LOB columns efficiently, making it suitable for a time-constrained migration. The 50 Mbps link can transfer approximately 1.5 TB in a week (50 Mbps * 604,800 seconds / 8 = ~3.78 TB raw capacity), but compression and overhead make DMS the most reliable choice for this scenario.
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 BCP to export the LOB table to flat files and then import to RDS.
Why it's wrong here
Data transfer over 50 Mbps may be too slow.
- ✗
Use SQL Server native backup and restore to RDS.
Why it's wrong here
Backup file transfer over 50 Mbps may exceed the time window.
- ✓
Use AWS DMS with compression enabled.
Why this is correct
DMS supports compression to reduce data transfer time.
- ✗
Create a read replica of the on-premises database and promote it.
Why it's wrong here
Read replicas are not supported for on-premises databases.
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.