AWS Certified Big Data – Specialty — Question 4

An administrator needs to design a strategy for the schema in a Redshift cluster. The administrator needs to determine the optimal distribution style for the tables in the Redshift schema.
In which two circumstances would choosing EVEN distribution be most appropriate? (Choose two.)

Answer options

• A. When the tables are highly denormalized and do NOT participate in frequent joins.
• B. When data must be grouped based on a specific key on a defined slice.
• C. When data transfer between nodes must be eliminated.
• D. When a new table has been loaded and it is unclear how it will be joined to dimension.

Correct answer: B, D

Explanation

Choosing EVEN distribution is suitable when the new table's joining method is unknown, making option D correct, as it allows for balanced data distribution without assumptions. Option B is also correct because EVEN distribution is effective when data does not need to be grouped by a key, allowing for efficient processing. Options A and C are incorrect as they imply specific join conditions or data transfer optimizations that are not relevant to EVEN distribution.