Câu 12: AWS Certified Big Data - Specialty (BDS-C00)

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

1. A. When the administrator needs to optimize a large, slowly changing dimension table. — đáp án hiện tại
2. B. When the administrator needs to reduce cross-node traffic.
3. C. When the administrator needs to optimize the fact table for parity with the number of slices. — đáp án hiện tại
4. D. When the administrator needs to balance data distribution and collocation data. — đáp án hiện tại
5. E. When the administrator needs to take advantage of data locality on a local node for joins and aggregates.