Courseiva
Deployment and MigrationhardMultiple ChoiceObjective-mapped

DBS-C01 Deployment and Migration Practice Question

A company is migrating a 1 TB Oracle database to Amazon RDS for Oracle. The source database has a high volume of small transactions. The migration must minimize source database impact. Which AWS DMS configuration should be used?

⚠ Common exam trap

Watch out — candidates often assume CDC is always necessary for a complete migration, but the question explicitly prioritizes minimizing source impact over minimizing downtime, making full load only the correct choice despite the lack of ongoing replication.

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

Use full load only and disable ongoing replication

Using full load only with ongoing replication disabled minimizes source database impact by avoiding the overhead of capturing and applying continuous change data capture (CDC) logs. The high volume of small transactions would otherwise generate a large number of redo log switches and increase I/O on the source, which is contrary to the requirement to minimize impact. A full load only migration transfers a snapshot of the data once, reducing the source load to a single consistent read operation.

Answer analysis

Option-by-option breakdown

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

  • Use batch-optimized apply mode

    Why it's wrong here

    Apply mode affects target, not source impact.

  • Use full load only and disable ongoing replication

    Why this is correct

    Full load only does not require CDC, minimizing impact.

  • Use full load with CDC (ongoing replication)

    Why it's wrong here

    CDC adds overhead to the source.

  • Use multiple DMS tasks to parallelize the migration

    Why it's wrong here

    More tasks increase source load.

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 →

How Courseiva writes practice questions · Editorial policy

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.