Courseiva
← DEA-C01
Full test
Data Operations and Support →easyMultiple ChoiceObjective-mapped

DEA-C01 Data Operations and Support Practice Question

A company runs an Amazon RDS for PostgreSQL database and wants to capture change data (inserts, updates, deletes) to stream into Amazon Kinesis Data Streams for real-time processing. Which AWS service should be used to capture the changes directly from the database?

⚠ Common exam trap

Test-takers frequently confuse scheduled polling (Glue) or file-based agents (Kinesis Agent) with true CDC, failing to recognize that only DMS ongoing replication can stream row-level changes directly from the database transaction log in real time.

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) with ongoing replication

AWS DMS with ongoing replication (change data capture) is the correct service because it can continuously capture insert, update, and delete operations from the PostgreSQL transaction logs (WAL) and stream them to a Kinesis Data Streams endpoint. This allows real-time processing without modifying the source database or requiring application-level triggers.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Amazon RDS automated snapshots

    Why it's wrong here

    Snapshots are point-in-time backups, not change streams.

  • ✗

    AWS Glue ETL job scheduled to run every minute

    Why it's wrong here

    Glue is batch-oriented, not real-time CDC.

  • ✗

    Amazon Kinesis Agent

    Why it's wrong here

    Kinesis Agent is for log files, not database CDC.

  • ✓

    AWS Database Migration Service (DMS) with ongoing replication

    Why this is correct

    DMS supports CDC and can stream changes to Kinesis.

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 →

How Courseiva writes practice questions · Editorial policy

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.