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?
- AALL distribution
- BEVEN distribution
- CAUTO distribution (correct answer)
- DKEY distribution
Reveal answer & explanationHide answer
The correct answer is C. Option C: AUTO distribution.