DEA-C01 Data Operations and Support Practice Question
A data engineer is migrating a legacy data warehouse to Amazon Redshift. The engineer needs to load data from multiple sources efficiently. Which THREE services can be used to load data into Redshift? (Choose THREE.)
⚠ Common exam trap
Candidates often think Kinesis Data Firehose delivers directly to Redshift, but it actually writes to S3 first. AWS DMS is a valid service for loading data, not just for migration.
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 the COPY command to load from Amazon DynamoDB.
The COPY command can load data from Amazon DynamoDB (A) and Amazon S3 (E) directly into Amazon Redshift. AWS DMS (C) can continuously replicate data from multiple sources into Redshift, making it a valid service for loading data. Option B (Kinesis Data Firehose) does not deliver data directly to Redshift; it writes to S3 first, then Redshift uses COPY. Option D (S3 Transfer Acceleration) accelerates uploads to S3, not loading into Redshift.
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 the COPY command to load from Amazon DynamoDB.
Why this is correct
Correct: The COPY command can load data directly from DynamoDB into Redshift.
- ✗
Use Kinesis Data Firehose to deliver data directly to Redshift.
Why it's wrong here
Incorrect: Kinesis Data Firehose delivers data to S3, not directly to Redshift.
- ✓
Use AWS DMS to replicate data continuously.
Why this is correct
Correct: AWS DMS can replicate data continuously into Redshift, making it a valid load service.
- ✗
Use S3 Transfer Acceleration.
Why it's wrong here
Incorrect: S3 Transfer Acceleration only speeds up uploads to S3, not loading into Redshift.
- ✓
Use the COPY command to load from Amazon S3.
Why this is correct
Correct: The COPY command can load data directly from S3 into Redshift.
Quick reference
AWS S3 Storage Class Comparison
| Storage Class | Min Duration | Retrieval | Use Case |
|---|---|---|---|
| S3 Standard | None | Immediate | Frequently accessed data |
| S3 Standard-IA | 30 days | Immediate | Infrequent access, rapid retrieval |
| S3 One Zone-IA | 30 days | Immediate | Non-critical infrequent data |
| S3 Intelligent-Tiering | None | Immediate–hours | Unknown or changing access patterns |
| S3 Glacier Instant | 90 days | Milliseconds | Archive with instant retrieval |
| S3 Glacier Flexible | 90 days | Minutes–hours | Archive, flexible retrieval |
| S3 Glacier Deep Archive | 180 days | Hours | Long-term compliance archive |
Go deeper
Related to this question
About these practice questions
This DEA-C01 question is part of Courseiva's 1,711-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 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.