IBM
C2090-303 · Question #106
You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and…
The correct answer is D. Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the. See the full explanation below for the reasoning.
Question
You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed. Which change will reduce the cost of partitioning that occurs in this job?
Exhibit
Options
- AUse Entire partitioning on the input links to the Aggregator and Join stages.
- BHash partition and sort on ZIP code column on the input links to the Aggregator and Join stages.
- CHash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning on the
- DHash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the
How the community answered
(41 responses)- A15% (6)
- B5% (2)
- C7% (3)
- D73% (30)
Community Discussion
No community discussion yet for this question.
