DEA-C01 Data Operations and Support Practice Question
A data engineer is using AWS Database Migration Service (AWS DMS) to migrate an on-premises Oracle database to Amazon Aurora PostgreSQL. The migration is running but the engineer observes that some tables are not being replicated. The DMS task logs show no errors, and the task status is 'Running'. Which action should the engineer take to identify the missing tables?
⚠ Common exam trap
The trap here is assuming that a running task with no errors is replicating all tables, but table mappings may exclude some tables by design.
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
✓
Check the DMS task's table mappings to ensure all required tables are included in the selection rules.
Table mappings in AWS DMS determine which tables are migrated. If tables are missing and no errors are present, the most likely cause is that the tables are not included in the selection rules. Reviewing and correcting the table mappings is the direct way to ensure all required tables are replicated.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Check the DMS task's table mappings to ensure all required tables are included in the selection rules.
Why this is correct
In AWS DMS, table mappings define which tables are included or excluded from the migration. If some tables are missing, it is likely that they are not covered by the selection rules. Reviewing and updating the table mappings to include the missing tables will ensure they are replicated. This is a common oversight when setting up DMS tasks.
- ✗
Enable CloudWatch Logs for the DMS task and look for warnings about table selection.
Why it's wrong here
CloudWatch Logs for DMS can provide detailed information, but if the task logs show no errors and the task is running, it is unlikely that warnings about missing tables will appear. The table mappings are the primary place to check. Enabling logs might provide additional context, but it is not the most direct action to identify missing tables.
- ✗
Increase the DMS replication instance size to handle more tables concurrently.
Why it's wrong here
The replication instance size affects performance and capacity, but the task is already running without errors. Missing tables are not due to insufficient resources; they are likely excluded by table mappings. Scaling up would not include tables that are not selected. It would incur additional cost without solving the problem.
- ✗
Restart the DMS task with the 'Reload target' option to force a full load of all tables.
Why it's wrong here
Restarting with reload target would truncate and reload all tables, which is disruptive and time-consuming. It does not address why specific tables are missing; if those tables are not in the table mappings, they will still be excluded. This action could cause data loss or duplication if not handled carefully, and it is not a diagnostic step.
Go deeper
Related to this question
About these practice questions
One of 1,321 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 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.