IBM
C2090-303 · Question #106
C2090-303 Question #106: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-303 to reveal the answer and full explanation for question #106. The question stem and answer options stay visible for context.
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
Unlock C2090-303 to see the answer
You've previewed enough free C2090-303 questions. Unlock C2090-303 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.