IBM
P2090-050 · Question #98
What will occur when two tables are joined together and the data is NOT collocated?
The correct answer is D. Data is dynamically redistributed or broadcasted. See the full explanation below for the reasoning.
Question
What will occur when two tables are joined together and the data is NOT collocated?
Options
- ANo data movement is required.
- BA merge join operation will be performed.
- CA cluster based join method is performed.
- DData is dynamically redistributed or broadcasted.
How the community answered
(50 responses)- A4% (2)
- B8% (4)
- C16% (8)
- D72% (36)
Community Discussion
No community discussion yet for this question.