IBM
A2090-560 · Question #41
What two conditions must be met to achieve a collocated join between two tables? (Choose two.)
The correct answer is D. Both join columns have identical data types. E. Both tables must be distributed on their join column. See the full explanation below for the reasoning.
Question
What two conditions must be met to achieve a collocated join between two tables? (Choose two.)
Options
- ABoth tables have primary keys defined.
- BBoth join columns have the same name.
- CBoth tables must be distributed on random.
- DBoth join columns have identical data types.
- EBoth tables must be distributed on their join column.
How the community answered
(22 responses)- A5% (1)
- B14% (3)
- C5% (1)
- D77% (17)
Community Discussion
No community discussion yet for this question.