SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is migrating its on-premises Oracle database to Amazon Aurora PostgreSQL using AWS DMS. The database has several large tables with hundreds of millions of rows. The migration must complete within a 2-hour downtime window. During the full load, DMS is running slowly on large tables. What should the company do to improve performance?
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
✓
Partition the large tables on the source and target, and use multiple DMS tasks.
Partitioning the large tables on both source and target allows AWS DMS to load multiple partitions in parallel using separate tasks, significantly improving throughput. Option A is incorrect because disabling foreign key constraints can cause data integrity issues and is not recommended for performance. Option B is incorrect because using a larger DMS instance would help, not a smaller one. Option C is incorrect because while LOB mode settings matter, they are not the primary bottleneck for full load of large tables; the key is parallelism via partitioning.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Disable foreign key constraints on the target during migration.
Why it's wrong here
Disabling foreign key constraints is not recommended and does not address the slow full load speed; proper migration should maintain referential integrity.
- ✗
Use a smaller DMS instance to avoid network bottlenecks.
Why it's wrong here
A smaller DMS instance would reduce resources, making performance worse; a larger instance with more vCPU and memory can help if the bottleneck is instance size.
- ✗
Set the LOB mode to 'Limited LOB mode' with a high max LOB size.
Why it's wrong here
LOB mode settings affect LOB handling, but the main issue for large tables is parallelism; limited LOB mode with high LOB size may help if LOBs are present, but the best general solution is partitioning.
- ✓
Partition the large tables on the source and target, and use multiple DMS tasks.
Why this is correct
Partitioning large tables enables parallel loading with multiple DMS tasks, which is the most effective way to speed up the full load within a tight downtime window.
Go deeper
Related to this question
About these practice questions
One of 1,660 original SAP-C02 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 SAP-C02 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 SAP-C02 exam.