DBS-C01 Deployment and Migration Practice Question
A company is migrating a 500 GB Oracle database to Amazon Aurora PostgreSQL. They need to convert the schema and migrate the data. The application uses Oracle-specific features like hierarchical queries and stored procedures. Which combination of services should they use?
⚠ Common exam trap
Many candidates assume DMS alone can handle schema conversion, but DMS only migrates data and requires SCT for schema transformation, especially when Oracle-specific features like hierarchical queries are involved.
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 Schema Conversion Tool (SCT) to convert the schema and AWS Database Migration Service (DMS) to migrate the data.
AWS SCT converts Oracle-specific schema objects (including hierarchical queries and stored procedures) to PostgreSQL-compatible code, while AWS DMS handles the ongoing data migration with minimal downtime. This combination is the standard AWS approach for heterogeneous database migrations, as SCT addresses schema conversion and DMS handles data transfer.
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 Edge to transfer the database files and then use SCT to convert the schema.
Why it's wrong here
Snowball transfers files, but the database must be stopped; SCT would need to be applied after transfer.
- ✓
Use AWS Schema Conversion Tool (SCT) to convert the schema and AWS Database Migration Service (DMS) to migrate the data.
Why this is correct
SCT converts the schema including Oracle-specific features, and DMS migrates the data efficiently.
- ✗
Use AWS Database Migration Service (DMS) with the Oracle as source and Aurora PostgreSQL as target.
Why it's wrong here
DMS migrates data but does not convert schema; Oracle-specific features would not be translated.
- ✗
Use AWS Schema Conversion Tool (SCT) to convert the schema and then manually export/import data.
Why it's wrong here
SCT converts schema but does not migrate data; manual export/import is error-prone and not recommended.
Go deeper
Related to this question
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 →
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.