A job contains a Sort stage that sorts a large volume of data across a cluster of servers. Due to
new requirements, the customer has requested that this sorting be done on a subset of servers
identified in the configuration file to minimize impact on database nodes. The
$APT_CONFIG_FILE shows no sort disk pool for any node. Which two steps will accomplish this?
(Choose two.)
A.
Assign a separate config file just for the Sort stage.
B.
Have an appropriate node constraint within the Sort stage.
C.
Use the environment variable $APT_SCRATCH_SPACE_SORT_USAGE.
D.
Define a non-default node pool with a subset of nodes in the parallel configuration file.
E.
Create a sort scratch disk pool with a subset of nodes in the parallel configuration file.
Explanation: