In which three circumstances would choosing Key-based distribution be most appropriate?

An administrator needs to design a distribution strategy for a star schema in a Redshift cluster. The administrator needs to determine the optimal distribution style for the tables in the Redshift schema.

In which three circumstances would choosing Key-based distribution be most appropriate? (Select three.)
A . When the administrator needs to optimize a large, slowly changing dimension table.
B . When the administrator needs to reduce cross-node traffic.
C . When the administrator needs to optimize the fact table for parity with the number of slices.
D . When the administrator needs to balance data distribution and collocation data.
E . When the administrator needs to take advantage of data locality on a local node for joins and aggregates.

View Answer

Answer: ACD