AWS Certified Big Data - Specialty (#9)

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.)

When the administrator needs to optimize a large, slowly changing dimension table.
When the administrator needs to reduce cross-node traffic.
When the administrator needs to optimize the fact table for parity with the number of slices.
When the administrator needs to balance data distribution and collocation data.
When the administrator needs to take advantage of data locality on a local node for joins and aggregates.

Need help?