Courseiva
Deployment and MigrationeasyMultiple ChoiceObjective-mapped

DBS-C01 Deployment and Migration Practice Question

A company needs to migrate an on-premises PostgreSQL database to Amazon Aurora PostgreSQL with minimal downtime. Which AWS service should be used for the ongoing replication?

⚠ Common exam trap

Many exam-takers confuse AWS DMS with AWS SCT, thinking SCT handles both schema conversion and data migration, but SCT only converts schemas and generates migration scripts, while DMS handles the actual data movement and 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

AWS Database Migration Service (DMS).

AWS Database Migration Service (DMS) supports ongoing replication (change data capture, CDC) from an on-premises PostgreSQL source to an Amazon Aurora PostgreSQL target using logical replication slots. This allows you to keep the target database synchronized with minimal downtime after the initial full load, making it the correct choice for a migration with minimal downtime.

Answer analysis

Option-by-option breakdown

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

  • AWS Glue.

    Why it's wrong here

    Glue is for ETL, not database replication.

  • AWS Backup.

    Why it's wrong here

    Backup is for snapshots, not replication.

  • AWS Database Migration Service (DMS).

    Why this is correct

    DMS provides CDC for ongoing replication.

  • AWS Schema Conversion Tool (SCT).

    Why it's wrong here

    Only converts schema.

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.