Answer-first summary for fast verification
Answer: AUTO distribution
Option C is CORRECT because AUTO distribution allows Amazon Redshift to automatically choose the optimal distribution style for the table based on the data and query patterns. This approach minimizes maintenance overhead, as the distribution style can adapt to changes in data or workload without manual intervention, making it the best choice when a suitable column for a distribution key is unavailable.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 39/58
A company uses Amazon Redshift as its data warehouse service. A data engineer needs to design a physical data model.
The data engineer encounters a de-normalized table that is growing in size. The table does not have a suitable column to use as the distribution key.
Which distribution style should the data engineer use to meet these requirements with the LEAST maintenance overhead?
A
ALL distribution
B
EVEN distribution
C
AUTO distribution
D
KEY distribution
No comments yet.