Courseiva
← DBS-C01
Full test
Deployment and Migration →hardMultiple ChoiceObjective-mapped

DBS-C01 Deployment and Migration Practice Question

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle using AWS DMS. The migration fails with an error indicating that DMS cannot capture changes from the source because the archive log mode is not enabled. What should be done?

⚠ Common exam trap

A common mix-up: candidates think disabling CDC (Option A) is a valid workaround, but the question implies the migration requires ongoing replication, and the error explicitly points to the missing archive log mode, not a choice to skip CDC.

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 archive log mode on the source Oracle database.

D is correct because AWS DMS requires archive log mode to be enabled on the source Oracle database for ongoing replication (CDC). Without archive logs, DMS cannot capture the redo data needed to apply changes to the target. Enabling archive log mode ensures the redo logs are preserved and accessible for change data capture.

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 ongoing replication and perform a full load only.

    Why it's wrong here

    While full load works, the company likely needs ongoing replication for minimal downtime.

  • ✗

    Set up an Oracle Data Guard standby and use it as the source.

    Why it's wrong here

    Data Guard does not help with DMS's requirement for archive logs.

  • ✗

    Use AWS Schema Conversion Tool (SCT) to convert the schema.

    Why it's wrong here

    SCT is for schema conversion, not for addressing log mode issues.

  • ✓

    Enable archive log mode on the source Oracle database.

    Why this is correct

    DMS requires archive logging to capture changes for ongoing replication.

About these practice questions

One of 1,663 original DBS-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 →

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.