DEA-C01 AWS Database Migration Service (DMS) Practice Question
A data engineer needs to ingest data from an on-premises Oracle database into Amazon S3 on a nightly basis. The data volume is approximately 10 GB per night. The database is accessible over the internet. Which AWS service is MOST appropriate for this task?
⚠ Common exam trap
Candidates may assume that AWS Glue is the only option for batch ETL from databases, but AWS DMS is purpose-built for database migrations and is often the recommended service for migrating or replicating data from on-premises databases to AWS, including direct to S3.
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 a JDBC connection
The most appropriate AWS service among the given options for nightly batch ingestion from an on-premises Oracle database into Amazon S3 is AWS Glue ETL job with a JDBC connection (A). AWS Glue can connect to the Oracle database via JDBC, extract data, and load it into S3 in a scheduled batch manner. While AWS Database Migration Service (DMS) is purpose-built for database migrations and would be the ideal service, it is not listed as an option. AWS DataSync (B) is used for file and object storage transfers, not for database connections. AWS Transfer Family (C) provides managed file transfer protocols and cannot directly query databases. Amazon Kinesis Data Streams (D) is designed for real-time streaming data ingestion, not nightly batch loads. Therefore, AWS Glue is the correct choice.
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 Glue ETL job with a JDBC connection
Why this is correct
AWS Glue ETL with JDBC can connect to Oracle and export data to S3, but it is less efficient than DMS for this use case. DMS handles schema extraction, data type conversion, and checkpoint resume automatically.
- ✗
AWS DataSync
Why it's wrong here
AWS DataSync is designed for moving large amounts of file data (e.g., NFS/SMB) over the internet, not for direct database connections.
- ✗
AWS Transfer Family
Why it's wrong here
AWS Transfer Family provides managed SFTP/FTPS endpoints; it cannot natively query an Oracle database.
- ✗
Amazon Kinesis Data Streams
Why it's wrong here
Amazon Kinesis Data Streams is for real-time streaming data ingestion, not for nightly batch processing of 10 GB.
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
One of 1,711 original DEA-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.