A Redshift cluster administrator must create a distribution plan for a star schema. The administrator must decide on the

[answerhappygod]

A Redshift cluster administrator must create a distribution plan for a star schema. The administrator must decide on the best distribution style for the Redshift schema's tables.

Which of the following three scenarios would make key-based distribution the most appropriate? (Choose 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.