A customer's Redshift schema requires determining the best distribution method for the ORDERS fact table. The ORDERS tab
Posted: Thu Jul 21, 2022 10:00 pm
A customer's Redshift schema requires determining the best distribution method for the ORDERS fact table. The ORDERS table in this design contains foreign key connections to several dimension tables.
How should the business select the ORDERS table's most suitable distribution key?
A. Identify the largest and most frequently joined dimension table and ensure that it and the ORDERS table both have EVEN distribution.
B. Identify the largest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.
C. Identify the smallest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.
D. 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.
How should the business select the ORDERS table's most suitable distribution key?
A. Identify the largest and most frequently joined dimension table and ensure that it and the ORDERS table both have EVEN distribution.
B. Identify the largest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.
C. Identify the smallest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.
D. 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.