DEA-C01 Data Store Management Practice Question
A company is migrating its on-premises Oracle data warehouse to Amazon Redshift. The data engineering team needs to load data from Oracle to Redshift using AWS DMS (Database Migration Service). The source database is 2 TB in size. The team wants to minimize downtime and ensure data consistency during full load. Which approach should they take?
⚠ Common exam trap
Candidates often confuse the UNLOAD command (Redshift export) with an Oracle export tool, or assume that a full database stop is required for consistency, when DMS's CDC capability eliminates that need.
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 to perform a full load, then enable ongoing replication to capture changes.
AWS DMS can perform a full load of the 2 TB Oracle database while simultaneously capturing ongoing changes via CDC (Change Data Capture). After the full load completes, DMS applies the cached changes to Redshift, ensuring data consistency with minimal downtime. This approach avoids stopping the source database and leverages DMS's native replication capabilities.
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 UNLOAD command to export data from Oracle to S3, then COPY into Redshift.
Why it's wrong here
UNLOAD is a Redshift command, not for Oracle.
- ✓
Use AWS DMS to perform a full load, then enable ongoing replication to capture changes.
Why this is correct
Minimizes downtime and ensures consistency.
- ✗
Stop the source database, export data to flat files, upload to S3, and use COPY to load into Redshift.
Why it's wrong here
Causes significant downtime.
- ✗
Use COPY command directly from Oracle to Redshift over JDBC.
Why it's wrong here
COPY reads from S3, not directly from Oracle.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DEA-C01 question from scratch — 1,711 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 DEA-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 DEA-C01 exam.