In the job fragment shown in the exhibit, there are two Sort stages: the first (Sort1) sorts the data
by state, the second (Sort2) sorts the data by state and area, No repartitioning occurs between the
stages.
You have been asked to reduce the number of sorts to improve the performance of the job.
Which two ways might be used to accomplish this without changing how the job functions? (Select
two)

A.
Remove the second Sort stage. Add area as an additional sort key.

B.
Remove the first Sort stage. Retain the existing sort keys in the second Sort stage.

C.
In the second Sort stage change the Sort Mode property of the area column to “Don’t sort,
previously sorted.”.

D.
In the second Sort stage change the Sort Mode property of the state column to “Don’t sort,
previously sorted.”.

Explanation: