DEA-C01 Data Ingestion and Transformation Practice Question
A data engineer is using AWS Database Migration Service (AWS DMS) to replicate ongoing changes from an on-premises Oracle database to an Amazon S3 bucket in near real time. The source table has a primary key and the database is configured for ARCHIVELOG mode. The engineer needs change data capture (CDC) to capture INSERT, UPDATE, and DELETE operations. Which AWS DMS task setting should be used to capture ongoing changes?
⚠ Common exam trap
The trap here is assuming that setting the migration type to 'cdc' alone is sufficient for Oracle, while overlooking the mandatory supplemental logging requirement on the source database.
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
✓
Set the migration type to 'full-load-and-cdc' and enable supplemental logging on the source table.
To capture ongoing changes from Oracle to S3 with AWS DMS, the task must be configured with migration type 'full-load-and-cdc' and supplemental logging must be enabled on the source. Supplemental logging provides the additional column data needed for UPDATE and DELETE operations. Without it, CDC cannot function correctly. The other options either use incorrect migration types or omit the critical supplemental logging requirement.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Set the migration type to 'full-load' and configure ongoing replication using Oracle GoldenGate.
Why it's wrong here
Setting the migration type to 'full-load' only performs a one-time load of existing data and does not capture subsequent changes. Oracle GoldenGate is a separate replication tool and is not part of AWS DMS. This approach would miss all ongoing INSERT, UPDATE, and DELETE operations after the initial load, failing the requirement.
- ✗
Set the migration type to 'cdc' only and rely on the Oracle redo logs without supplemental logging.
Why it's wrong here
While 'cdc' only captures changes, AWS DMS still requires supplemental logging enabled on the source Oracle database to capture column-level data for updates and deletes. Without supplemental logging, DMS cannot reliably capture before-image values, leading to incomplete or incorrect CDC records. Additionally, starting with CDC only skips existing data, which may not be desired.
- ✓
Set the migration type to 'full-load-and-cdc' and enable supplemental logging on the source table.
Why this is correct
For Oracle CDC, AWS DMS requires supplemental logging to be enabled at the database or table level to capture column data for updates and deletes. The migration type 'full-load-and-cdc' performs an initial full load and then continues capturing ongoing changes, satisfying the requirement for near real-time replication of INSERT, UPDATE, and DELETE operations.
- ✗
Set the migration type to 'full-load-and-cdc' and increase the commit rate to reduce latency.
Why it's wrong here
Increasing the commit rate can improve performance but does not address the fundamental requirement for Oracle CDC: supplemental logging must be enabled. Without supplemental logging, DMS cannot capture the necessary column data for updates and deletes, resulting in incomplete CDC. The commit rate setting alone does not enable CDC functionality.
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,321 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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Amazon Web Services exam blueprint
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.