What two conditions must be met to achieve a collocated join between two tables? (Choose two.)

A.
“Both tables have primary keys defined.

B.
“Both join columns have the same name.

C.
“Both tables must be distributed on random.

D.
“Both join columns have identical data types.

E.
“Both tables must be distributed on their join column.

Explanation: