Your company is going to create a table in a Redshift cluster. Below are the key characteristics for the table:
The data in the table don’t change frequently.
There would be less than 10 millions rows.
The table would have joined with other tables.
Which of the following distribution styles would be ideal for the table?

Answer options:

A.All
B.Default
C.EVEN
D.Key

Answer – A
The AWS Documentation mentions the following
ALL distribution multiplies the storage required by the number of nodes in the cluster, and so it takes much longer to load, update, or insert data into multiple tables. ALL distribution is appropriate only for relatively slow moving tables; that is, tables that are not updated frequently or extensively. Small dimension tables do not benefit significantly from ALL distribution, because the cost of redistribution is low.
Since the concept of this distribution style is clearly mentioned in the documentation , all other options are incorrect
For more information on Distribution styles, please refer to the below URL
https://docs.aws.amazon.com/redshift/latest/dg/c_choosing_dist_sort.html