DBS-C01 Deployment and Migration Practice Question
A company is migrating a 3 TB Oracle database from on-premises to Amazon RDS for Oracle. The migration must have zero downtime. The on-premises server uses Oracle Data Guard for disaster recovery. The network bandwidth is 200 Mbps. The team plans to use AWS DMS with CDC from Oracle redo logs. During the initial full load, DMS reports that the source table 'ORDERS' has a table-level supplemental log missing. The migration fails. What should the team do first to resolve this issue?
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
✓
Enable supplemental logging on the Oracle source database for the 'ORDERS' table.
AWS DMS requires supplemental logging on the source Oracle tables to capture change data for CDC. Without it, DMS cannot track changes. Option A is incorrect because switching to Oracle GoldenGate would not address the root cause and adds complexity. Option B is incorrect because using AWS SCT and native export/import does not provide zero-downtime migration. Option D is incorrect because recreating the task with 'full load only' would lose the CDC requirement, causing downtime for ongoing changes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Switch to Oracle GoldenGate for migration.
Why it's wrong here
Additional cost and complexity; not necessary.
- ✗
Use AWS SCT to convert the schema and then use a native export/import.
Why it's wrong here
Would cause downtime.
- ✓
Enable supplemental logging on the Oracle source database for the 'ORDERS' table.
Why this is correct
Required for DMS CDC to capture changes.
- ✗
Recreate the DMS task with 'full load only' to bypass CDC.
Why it's wrong here
Would not achieve zero downtime.
Visual reference
Go deeper
Related to this question
About these practice questions
Courseiva writes every DBS-C01 question from scratch — 1,663 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 DBS-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 DBS-C01 exam.