DBS-C01 Deployment and Migration Practice Question
A company is migrating a 500 GB PostgreSQL database from on-premises to Amazon Aurora PostgreSQL. The migration must be completed within 6 hours with minimal downtime. The on-premises network bandwidth is 500 Mbps. The team decides to use AWS DMS. During initial full load, DMS reports a 'Target metadata error: cannot write to Aurora' for a specific table. Investigation shows that the table has a trigger that tries to insert into an external web service. What should the team do 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
✓
Disable the trigger on the target Aurora database during migration.
Disabling the trigger on the target Aurora PostgreSQL database during migration prevents the trigger from firing, which was causing the 'Target metadata error: cannot write to Aurora' error. The trigger's attempt to insert into an external web service is not compatible with DMS loading data. Option B is incorrect because increasing the DMS replication instance size does not address the trigger issue. Option C is incorrect because upgrading the DMS replication instance engine version does not address the trigger issue. Option D is incorrect because disabling the trigger on the source database does not prevent the trigger on the target from firing when DMS writes data; the error occurs on the target.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Disable the trigger on the target Aurora database during migration.
Why this is correct
This is correct. Disabling the trigger on the target database during migration stops the external web service call, resolving the error.
- ✗
Increase the DMS replication instance size.
Why it's wrong here
This is incorrect. Increasing the DMS replication instance size increases resources but does not fix the trigger-related error.
- ✗
Upgrade the DMS replication instance engine version.
Why it's wrong here
This is incorrect. Upgrading the DMS engine version does not address the trigger issue.
- ✗
Disable the trigger on the source database.
Why it's wrong here
This is incorrect. Disabling the trigger on the source database does not affect the target trigger behavior, so the error persists.
Visual reference
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-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 →
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.