Courseiva
Deployment and MigrationmediumMultiple ChoiceObjective-mapped

DBS-C01 Deployment and Migration Practice Question

A company is migrating a 2 TB on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The migration must have minimal downtime and support ongoing replication. Which AWS service should be used?

⚠ Common exam trap

Many exam-takers assume native PostgreSQL logical replication (Option D) is always the best choice for minimal-downtime migrations, but they overlook that DMS provides a fully managed, AWS-integrated solution that handles schema conversion, monitoring, and automatic failover, which is essential for a 2 TB database migration with 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 DMS

AWS DMS (Database Migration Service) is the correct choice because it supports both full-load migration and ongoing change data capture (CDC) replication from an on-premises PostgreSQL source to Amazon RDS for PostgreSQL, enabling minimal downtime. DMS uses logical replication slots to capture incremental changes, allowing the target database to stay synchronized during the cutover window.

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 DMS

    Why this is correct

    DMS supports ongoing replication from on-premises to RDS, minimizing downtime.

  • AWS Snowball Edge

    Why it's wrong here

    Snowball is for offline data transfer, not for minimal-downtime online migration with replication.

  • AWS S3

    Why it's wrong here

    S3 is an object storage service, not designed for database migration with ongoing replication.

  • RDS native PostgreSQL logical replication

    Why it's wrong here

    RDS does not support native pglogical replication from external sources; DMS is the recommended tool.

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 →

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.