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…

Question

Options

• AALL distribution
• BEVEN distribution
• CAUTO distribution
• DKEY distribution

• A
  6% (3)
• B
  2% (1)
• C
  81% (39)
• D
  10% (5)

Explanation

AUTO distribution allows Amazon Redshift to automatically manage the distribution style based on the size of the table. With this option, Redshift chooses the most optimal distribution method, and as the table grows, it will adjust the distribution style to maintain performance. This minimizes maintenance overhead since the system adapts without the need for manual tuning. ALL distribution copies the entire table to all nodes. It can be useful for small, static tables but is inefficient for large or growing tables as it increases storage and I/O costs significantly. EVEN distribution distributes rows evenly across all nodes. While it reduces data skew, it may not be optimal for larger tables where certain queries would benefit from co-locating data to minimize cross-node traffic. KEY distribution places data based on the values in a specific column (distribution key). Since the question states that no suitable column exists for a distribution key, this method would not be

No community discussion yet for this question.