In which two circumstances would choosing EVEN distribution be most appropriate?

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 on the Redshift schema.

In which two circumstances would choosing EVEN distribution be most appropriate? (Select two)
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 tables

View Answer

Answer: A,D

Explanation:

https://docs.aws.amazon.com/redshift/latest/dg/c_choosing_dist_sort.html