DEA-C01 KEY distribution style Practice Question
Which THREE are valid Amazon Redshift distribution styles? (Choose 3.)
⚠ Common exam trap
The trap is that candidates may think AUTO is not a valid style because it’s newer, but it is a first-class distribution style in Amazon Redshift.
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
✓
ALL
All three distribution styles—ALL, AUTO, and KEY—are valid in Amazon Redshift. AUTO lets Redshift choose the distribution style based on table size and query patterns, ALL copies the entire table to every node for small dimension tables, and KEY distributes rows based on a specified column. The options HASH and RANDOM are not valid distribution styles.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
HASH
Why it's wrong here
HASH is not a valid Amazon Redshift distribution style. Valid styles are KEY, ALL, EVEN, and AUTO.
- ✓
ALL
Why this is correct
ALL is a valid distribution style; it replicates the entire table to every node.
- ✓
AUTO
Why this is correct
AUTO is a valid distribution style; it lets Redshift automatically choose the distribution method.
- ✗
RANDOM
Why it's wrong here
RANDOM is not a valid Amazon Redshift distribution style. Valid styles are KEY, ALL, EVEN, and AUTO.
- ✓
KEY
Why this is correct
KEY is a valid distribution style; it distributes rows based on a specified column value.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DEA-C01 question from scratch — 1,711 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 DEA-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 DEA-C01 exam.