DBS-C01 Workload-Specific Database Design Practice Question
A company is migrating a large Oracle data warehouse to Amazon Redshift. The source database has many complex stored procedures, views, and joins. Which THREE actions should the company take during the migration?
⚠ Common exam trap
It's easy for candidates to assume traditional database features like triggers and indexes are universally applicable, but Redshift intentionally omits them for performance and scalability, and the exam tests understanding of Redshift's unique design trade-offs.
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 the AWS Schema Conversion Tool (SCT) to convert stored procedures.
AWS Schema Conversion Tool (SCT) is the recommended tool for converting Oracle stored procedures, functions, and packages to Amazon Redshift's PL/pgSQL-compatible language. It automates the translation of complex procedural logic, reducing manual effort and errors during migration. Redshift does not support Oracle-specific PL/SQL constructs natively, so SCT handles syntax and semantic conversion.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Migrate triggers as they are in Redshift.
Why it's wrong here
Redshift does not support triggers.
- ✓
Use the AWS Schema Conversion Tool (SCT) to convert stored procedures.
Why this is correct
SCT converts database schema and code.
- ✗
Recreate all indexes from Oracle in Redshift.
Why it's wrong here
Redshift uses sort keys, not indexes.
- ✓
Denormalize the schema to reduce the number of joins.
Why this is correct
Redshift performs better with denormalized data.
- ✓
Design the schema using a star schema with fact and dimension tables.
Why this is correct
Redshift is optimized for star schema.
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.