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?

A.
Use Entire partitioning on the input links to the Aggregator and Join stages.

B.
Hash partition and sort on ZIP code column on the input links to the Aggregator and Join
stages.

C.
Hash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning
on the Aggregator and Join stages.

D.
Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning
on the Aggregator and Join stages.

Explanation: