SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is migrating a data warehouse from on-premises to Amazon Redshift. The current workload runs complex queries that join large tables. The company wants to optimize query performance after migration. Which design should the company implement?
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 distribution style KEY on the join columns of large tables
Distribution style KEY on join columns ensures data is co-located, minimizing data movement. Option A (AUTO) may not use the optimal distribution strategy. Option B (EVEN) distributes rows evenly, which can cause significant data movement across nodes. Option C (ALL) is not suitable for large tables because it duplicates the entire table on every node, leading to high storage and performance issues.
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 distribution style AUTO and let Redshift decide
Why it's wrong here
AUTO may not always choose the best distribution for complex queries.
- ✗
Use distribution style EVEN on all tables
Why it's wrong here
EVEN distributes rows randomly, leading to data shuffling during joins.
- ✗
Use distribution style ALL on all large tables
Why it's wrong here
ALL replicates data to all nodes, causing high storage and performance issues for large tables.
- ✓
Use distribution style KEY on the join columns of large tables
Why this is correct
Co-locates rows from different tables on the same node, avoiding data movement.
Go deeper
Related to this question
About these practice questions
One of 1,660 original SAP-C02 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 SAP-C02 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 SAP-C02 exam.