AWS Certified Big Data - Specialty (#55)

A customer needs to determine the optimal distribution strategy for the ORDERS fact table in its Redshift schema. The ORDERS table has foreign key relationships with multiple dimension tables in this schema. How should the company determine the most appropriate distribution key for the ORDERS table?

Identify the largest and most frequently joined dimension table and ensure that it and the ORDERS table both have EVEN distribution.
Identify the largest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.
Identify the smallest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.
Identify the largest and the most frequently joined dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.

Need help?