A company is planning on sending and storing historical data for an application in a Redshift cluster. The tables being transferred will consist of large fact and large dimension tables. Join queries need to be optimized between the two tables. Which of the following is the ideal distribution style to use for the fact table?

Answer options:

A.Even
B.Key
C.Primary
D.All

Answer - B
The AWS Documentation mentions the following
########
Choose the Best Distribution Style
When you execute a query, the query optimizer redistributes the rows to the compute nodes as needed to perform any joins and aggregations. The goal in selecting a table distribution style is to minimize the impact of the redistribution step by locating the data where it needs to be before the query is executed.
Distribute the fact table and one dimension table on their common columns.
Your fact table can have only one distribution key. Any tables that join on another key aren`t collocated with the fact table. Choose one dimension to collocate based on how frequently it is joined and the size of the joining rows. Designate both the dimension table`s primary key and the fact table`s corresponding foreign key as the DISTKEY.
########
Since this is clearly mentioned in the AWS Documentation, all other options are invalid.
For more information on choosing the best distribution style, please refer to the below URL
https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-best-dist-key.html