Courseiva
← PAS-C01
Full test
Migration →hardMultiple ChoiceObjective-mapped

PAS-C01 Migration Practice Question

Exhibit

Refer to the exhibit.

Error from AWS DMS task:
"Last Error: Failed to start change data capture for table 'sales.orders'.
Details: The source database is not configured for full supplemental logging. To enable full supplemental logging, run: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;"

A team is migrating an Oracle database to Amazon RDS for MySQL using AWS DMS with ongoing replication (CDC). The initial load succeeded, but the CDC task fails with the error shown in the exhibit. The source Oracle database is on-premises. Which action should the team take to resolve the issue?

⚠ Common exam trap

A common mix-up: candidates assume the issue is on the target side (e.g., binary logging) or that a simple restart will fix transient errors, but AWS DMS CDC failures from Oracle almost always point to missing supplemental logging on the source.

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

✓

Connect to the source Oracle database and enable full supplemental logging by executing the command: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

AWS DMS requires full supplemental logging on the source Oracle database to capture all column values for CDC (ongoing replication). Without it, DMS cannot reconstruct the complete row changes from the redo logs, causing the CDC task to fail. Enabling full supplemental logging with `ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;` ensures that every column is logged, allowing DMS to replicate all changes correctly.

Answer analysis

Option-by-option breakdown

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

  • ✗

    Configure binary logging on the target MySQL RDS instance.

    Why it's wrong here

    The error is about the source Oracle database, not the target MySQL.

  • ✗

    Stop and restart the DMS task to clear the error.

    Why it's wrong here

    Restarting without fixing the logging will cause the same error again.

  • ✗

    Switch the target database to Amazon RDS for Oracle to maintain compatibility.

    Why it's wrong here

    Changing the target engine is not required; the issue is with source logging.

  • ✓

    Connect to the source Oracle database and enable full supplemental logging by executing the command: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

    Why this is correct

    This command enables the required logging for CDC to work.

Visual reference

Client Recursive Resolver Root DNS (13 root servers) TLD DNS (.com, .org, …) Authoritative example.com query IP addr answer

About these practice questions

This PAS-C01 question is part of Courseiva's 1,616-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 →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This PAS-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 PAS-C01 exam.