DEA-C01 Data Store Management Practice Question
A financial services company stores transaction data in Amazon RDS for PostgreSQL. The company requires that all changes to the database be logged for audit purposes, including before and after images of updated rows. Which feature should the data engineer enable?
⚠ Common exam trap
Watch out — candidates often confuse database-level logging features (like Enhanced Monitoring or automated backups) with row-level change data capture, assuming any logging mechanism will capture before-and-after images, when only logical replication (or triggers with audit tables) provides that granularity.
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 up logical replication using pglogical or native publication/subscription
Logical replication, using either pglogical or native PostgreSQL publication/subscription, captures row-level changes (INSERT, UPDATE, DELETE) and can include both the old and new values of updated rows. This meets the audit requirement for before-and-after images, as logical replication decodes the write-ahead log (WAL) to produce a change stream that includes full row snapshots.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable automated backups and export logs to Amazon S3
Why it's wrong here
Backups capture point-in-time snapshots, not incremental changes with before/after images.
- ✗
Enable Enhanced Monitoring and publish logs to CloudWatch Logs
Why it's wrong here
Enhanced Monitoring captures OS metrics, not data changes.
- ✓
Set up logical replication using pglogical or native publication/subscription
Why this is correct
Logical replication provides row-level changes with before and after images.
- ✗
Enable Multi-AZ deployment and read replicas
Why it's wrong here
Multi-AZ provides failover, not change capture.
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.