nerdexam
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

C2090-303 question #106 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)
  • A
    15% (6)
  • B
    5% (2)
  • C
    7% (3)
  • D
    73% (30)

Community Discussion

No community discussion yet for this question.

Full C2090-303 Practice