A company is planning on hosting their data warehousing solution in Redshift. They are trying to decide on the distribution style for their underlying tables. Which of the following reasons would warrant the use of EVEN distribution style for the underlying tables in Redshift. Choose 2 answers from the options given below

Answer options:

A.When a table does not participate in joins
B.When the table participates in multiple joins
C.When the tables design is new and there is no clear distinction on how the data will be organized
D.When there is a requirement for queries for keys to be co-located.

Answer – A and C
The AWS Documentation mentions the following
#######
Distribution Styles
When you create a table, you can designate one of three distribution styles; EVEN, KEY, or ALL.
Even distribution
The leader node distributes the rows across the slices in a round-robin fashion, regardless of the values in any particular column. EVEN distribution is appropriate when a table does not participate in joins or when there is not a clear choice between KEY distribution and ALL distribution.
#######
Since this is clearly mentioned in the documentation, the other options are invalid
For more information on choosing the right distribution style , please refer to the below URL
https://docs.aws.amazon.com/redshift/latest/dg/c_choosing_dist_sort.html