DEA-C01 Data Ingestion and Transformation Practice Question
Which TWO options are valid methods to ingest on-premises relational database data into Amazon S3 for analytics? (Choose 2.)
⚠ Common exam trap
Many candidates confuse AWS Glue ETL (which uses JDBC for batch extraction) with Amazon Kinesis (which is for streaming), or they overlook that AWS DMS is a dedicated service for database migration and replication to S3, while Snowball Edge is for offline bulk transfer, not live ingestion.
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 Glue ETL job with JDBC connection to source
AWS Glue ETL jobs can connect to on-premises relational databases via JDBC, extract data, and write it directly to Amazon S3 in formats like Parquet or ORC. This is a fully managed, serverless approach suitable for batch ingestion and transformation of structured data for analytics.
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 Snowball Edge
Why it's wrong here
Snowball is for large offline data transfer, not real-time.
- ✓
AWS Glue ETL job with JDBC connection to source
Why this is correct
Glue can read from JDBC and write to S3.
- ✗
Amazon Kinesis Data Streams with Direct Put
Why it's wrong here
Kinesis is for streaming, not direct database ingestion.
- ✓
AWS Database Migration Service (DMS) with S3 target
Why this is correct
DMS supports S3 as a target for full load and CDC.
- ✗
Amazon AppFlow
Why it's wrong here
AppFlow is for SaaS applications, not on-prem databases.
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,321-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 →
Same concept, more angles
1 more way this is tested on DEA-C01
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Which TWO AWS services can be used to ingest data from an on-premise relational database into Amazon S3 on a one-time basis?
easy- A.AWS Data Pipeline
- ✓ B.AWS Database Migration Service (DMS)
- ✓ C.AWS Glue
- D.Amazon Simple Queue Service (SQS)
- E.Amazon Kinesis Data Streams
Why B: AWS Database Migration Service (DMS) (B) is correct because it can perform a one-time full-load migration from an on-premise relational database directly into Amazon S3, using S3 as the target endpoint without ongoing replication. AWS Glue (C) is correct because its ETL jobs and crawlers can connect to an on-premise relational database via JDBC and write the extracted data into Amazon S3 in a single batch run. AWS Data Pipeline (A) is not the intended answer here since it is more commonly used for orchestrating scheduled or recurring data movement rather than a straightforward one-time relational-to-S3 ingestion. Amazon SQS (D) is a message queuing service and cannot connect to a relational database or load data into S3. Amazon Kinesis Data Streams (E) is designed for real-time streaming ingestion, not one-time bulk extraction from a relational database.
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.