Topic 1 Question 161

AWS Certified Data Engineer - Associate

Topic 1 Question 161
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?
- ALL distribution
- EVEN distribution
- AUTO distribution
- KEY distribution
ユーザの投票
コメント(3)
- 正解だと思う選択肢: B
  If the table grows larger and none of the columns are suitable to be the distribution key, Amazon Redshift changes the distribution style to EVEN.
  
  👍 2
  jacob_nz2024/11/22
- 正解だと思う選択肢: C
  https://docs.aws.amazon.com/redshift/latest/dg/c_choosing_dist_sort.html
  
  👍 2
  emupsx12024/11/24
- 正解だと思う選択肢: C
  the LEAST maintenance overhead = C
  
  With AUTO distribution, Amazon Redshift assigns an optimal distribution style based on the size of the table data. For example, if AUTO distribution style is specified, Amazon Redshift initially assigns the ALL distribution style to a small table. When the table grows larger, Amazon Redshift might change the distribution style to KEY, choosing the primary key (or a column of the composite primary key) as the distribution key. If the table grows larger and none of the columns are suitable to be the distribution key, Amazon Redshift changes the distribution style to EVEN. The change in distribution style occurs in the background with minimal impact to user queries.
  
  👍 2
  idenrai2024/12/09
シャッフルモード

ユーザの投票

コメント(3)