DBS-C01 Deployment and Migration Practice Question
A company is planning to migrate a 5 TB Oracle data warehouse to Amazon Redshift. They need to transform the data during migration. Which AWS service should they use to perform the transformation?
⚠ Common exam trap
Candidates often confuse AWS DMS's transformation rules (which handle simple schema mapping) with the full ETL capabilities needed for data warehouse migration, leading them to choose DMS instead of Glue.
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 Glue to perform extract, transform, and load (ETL) jobs.
AWS Glue is the correct choice because it is a fully managed ETL service designed for data transformation and loading into Amazon Redshift. It can handle the 5 TB Oracle data warehouse migration by running Spark-based ETL jobs that transform the data before writing it to Redshift, making it ideal for batch-oriented data warehouse migrations.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Amazon Kinesis Data Analytics for real-time transformation.
Why it's wrong here
Kinesis is for streaming data, not for batch transformation of large datasets.
- ✗
Amazon Athena to query the source data and write results to Redshift.
Why it's wrong here
Athena is for querying data in S3, not for ETL transformations.
- ✓
AWS Glue to perform extract, transform, and load (ETL) jobs.
Why this is correct
Glue is a fully managed ETL service suitable for transforming data before loading into Redshift.
- ✗
AWS Database Migration Service (DMS) with transformation rules.
Why it's wrong here
DMS is primarily for replication and offers limited transformation capabilities.
Go deeper
Related to this question
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 →
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.