DBS-C01 Deployment and Migration Practice Question
A company is migrating a 500 GB Oracle database to Amazon Aurora PostgreSQL. Which THREE steps should be part of the migration plan?
⚠ Common exam trap
Test-takers frequently confuse network connectivity tools (Direct Connect) or offline transfer methods (Snowball) with actual migration services, overlooking that DMS and SCT are the core services for heterogeneous database migrations, while Direct Connect is an optional optimization, not a required step.
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 AWS DMS to perform a full load and ongoing replication from Oracle to Aurora.
AWS DMS supports heterogeneous migrations from Oracle to Aurora PostgreSQL, performing a full load followed by ongoing change data capture (CDC) using Oracle's redo logs to replicate changes with minimal downtime. This makes it the correct service for both the initial data transfer and continuous replication during migration.
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 AWS Snowball to transfer the database files.
Why it's wrong here
Snowball transfers physical storage devices, but Aurora PostgreSQL migration requires continuous replication of live transactional data, not static file shipment. It is tempting because Snowball efficiently handles large offline datasets for one-time bulk loads into Amazon S3, which would be correct for migrating a cold database backup to S3 before using AWS Database Migration Service.
- ✗
Set up AWS Direct Connect between on-premises and AWS.
Why it's wrong here
Direct Connect is helpful but not a required step in migration plan.
- ✓
Use AWS DMS to perform a full load and ongoing replication from Oracle to Aurora.
Why this is correct
DMS supports Oracle as source and Aurora PostgreSQL as target.
- ✓
Use AWS SCT to convert the Oracle schema to PostgreSQL-compatible schema.
Why this is correct
SCT converts schema objects like tables, views, stored procedures.
- ✓
Validate the migrated data and test the application against the new database.
Why this is correct
Testing is essential to ensure correctness and performance.
Go deeper
Related to this question
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 →
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.