DBS-C01 Deployment and Migration Practice Question
An e-commerce company is migrating its PostgreSQL database to Amazon RDS for PostgreSQL. The database has multiple large tables (over 500 GB each) and the migration window is only 2 hours. Which strategy would be MOST effective to meet the time constraint?
⚠ Common exam trap
Many candidates assume a single DMS task with full LOB mode is sufficient for large tables, underestimating the severe performance penalty of sequential LOB processing, and overlook the parallel load feature designed specifically for this scenario.
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 parallel load by splitting tables into multiple tasks.
AWS DMS with parallel load by splitting tables into multiple tasks allows concurrent data transfer across multiple threads, maximizing throughput for large tables. This approach directly addresses the 2-hour migration window by distributing the workload, whereas a single task would be bottlenecked by sequential processing. Parallel load is specifically designed for high-volume migrations where time is critical.
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 a single DMS task with full LOB mode.
Why it's wrong here
Single task with full LOB is slower.
- ✓
Use AWS DMS with parallel load by splitting tables into multiple tasks.
Why this is correct
Parallel load accelerates migration.
- ✗
Increase the RDS instance size and use pg_dump.
Why it's wrong here
pg_dump is serial and might not finish in 2 hours.
- ✗
Use AWS SCT to optimize schema and then one DMS task.
Why it's wrong here
SCT doesn't improve data transfer speed.
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.