SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is migrating its on-premises data warehouse to Amazon Redshift. The existing system uses PostgreSQL and has 10 TB of data. The migration must be completed within a 4-hour downtime window. The company has a 1 Gbps AWS Direct Connect connection. After starting the migration using AWS DMS with a full load and CDC, the full load takes 6 hours. What should the company do to meet the downtime window?
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
✓
Configure multiple DMS tasks to load different tables in parallel.
The full load took 6 hours, exceeding the 4-hour downtime window. To meet the window, the company must reduce the time for the full load. Configuring multiple DMS tasks to load different tables in parallel (Option A) can significantly speed up the full load by distributing the workload across multiple tasks. Option B (Snowball Edge) would involve physical shipping and manual steps, which would not meet the 4-hour window. Option C (archiving old records) might reduce data volume but would require additional analysis and may not be feasible within the window. Option D (VPN) would likely have lower bandwidth than Direct Connect, making the load slower, not faster.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Configure multiple DMS tasks to load different tables in parallel.
Why this is correct
Parallelism improves speed.
- ✗
Use AWS Snowball Edge to transfer the data physically.
Why it's wrong here
Using AWS Snowball Edge would fail because the 10 TB data volume, while physically shippable, cannot be loaded into Redshift and then synchronised with ongoing CDC changes within the 4-hour window — the device must be shipped, connected, and the data ingested, which alone exceeds the allowed downtime. This option is tempting because Snowball Edge is designed for large offline data transfers when network bandwidth is insufficient, and would be correct if the Direct Connect link were slower or unavailable and no CDC catch-up was required.
- ✗
Reduce the amount of data by archiving older records.
Why it's wrong here
Cannot change data volume.
- ✗
Use AWS VPN instead of Direct Connect for higher bandwidth.
Why it's wrong here
VPN is not faster.
Go deeper
Related to this question
About these practice questions
This SAP-C02 question is part of Courseiva's 1,660-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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 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.