DEA-C01 Data Ingestion and Transformation Practice Question
Which TWO AWS services can be used to ingest data from an on-premise relational database into Amazon S3 on a one-time basis?
⚠ Common exam trap
The trap here is that candidates might think Glue is only for scheduled or recurring jobs, but Glue ETL jobs can be triggered on-demand for a one-time migration. Also, some might confuse Kinesis or SQS as suitable for one-time batch ingestion, but those are designed for streaming data.
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
✓
AWS Database Migration Service (DMS)
AWS DMS can perform one-time full-load migrations from on-premise relational databases to Amazon S3 by connecting to the source and writing data directly to S3 in formats like CSV or Parquet. AWS Glue can also be used for one-time data ingestion by creating an ETL job that reads from the source database via JDBC and writes to S3, with the option to run the job on demand. Both services support one-time transfers without ongoing replication.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
AWS Data Pipeline
Why it's wrong here
AWS Data Pipeline is tempting as it's designed for data movement and transformation, and could certainly move data from an on-premise source. However, it is not ideal for a one-time ingestion into S3 because it is primarily intended for recurring, scheduled data processing workflows, not a single, ad-hoc transfer.
- ✓
AWS Database Migration Service (DMS)
Why this is correct
AWS Database Migration Service (DMS) is correct. It can perform a one-time full-load migration from an on-premise relational database directly to Amazon S3, supporting multiple output formats.
- ✓
AWS Glue
Why this is correct
AWS Glue is correct. It can connect to JDBC sources and run a one-time ETL job to ingest data into S3. While it requires a script, it is a valid option for one-time ingestion.
- ✗
Amazon Simple Queue Service (SQS)
Why it's wrong here
Amazon Simple Queue Service (SQS) is a message queuing service, not designed for database ingestion. It would require custom producers and consumers to move data.
- ✗
Amazon Kinesis Data Streams
Why it's wrong here
Amazon Kinesis Data Streams is for real-time streaming data, not for one-time bulk loads from a relational database.
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
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.