Question 233 of 1,711
DEA-C01 Data Operations and Support Practice Question
A data engineer is designing an Amazon Redshift data warehouse for a high-traffic analytics workload. The engineer needs to ensure fast query performance and minimize data movement. Which THREE design decisions should be made? (Choose THREE.)
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
✓
Choose DISTSTYLE KEY for tables that are frequently joined.
Correct answers are A, D, and E. DISTSTYLE KEY on frequently joined tables collocates data on the same node, reducing data movement during joins. Applying compression encodings reduces storage and I/O, improving performance. SORT KEYs on columns used in WHERE clauses enable efficient range-restricted scans. Option B is incorrect because the default distribution style (AUTO) may not be optimal; explicit distribution is better for performance. Option C is incorrect because DISTSTYLE ALL stores a copy of the table on every node, which increases storage and load time; it is suitable only for small dimension tables, not large fact tables.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Choose DISTSTYLE KEY for tables that are frequently joined.
Why this is correct
KEY distribution collocates rows based on join keys, reducing data movement.
- ✗
Use the default distribution style for all tables.
Why it's wrong here
Default AUTO may not be optimal for performance.
- ✗
Use DISTSTYLE ALL for all large fact tables.
Why it's wrong here
ALL distributes entire table to all nodes, increasing storage and load time.
- ✓
Apply appropriate compression encodings to columns.
Why this is correct
Compression reduces storage and I/O.
- ✓
Define SORT KEYs on columns used in WHERE clauses.
Why this is correct
Sort keys minimize scanning.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 20, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.