Multiple choice technology platforms and products

Which of the following could be modified to improve the performance of a job which is using a sort stage executing slow due to the amount of data processed?

  1. Environmental variable APT_AUTO_TRANSPORT_SIZE

  2. Environmental variable APT_SORT_MEMORY_SIZE

  3. Sort stage Restrict memory usage property

  4. Sort stage Max memory limit property
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a Sort stage performs slowly due to large data volumes, you can restrict memory usage to force disk-based sorting. This prevents excessive memory consumption that can cause swapping or resource contention. APT_SORT_MEMORY_SIZE is an environment variable, while Max memory limit is a different property.

Keep practicing — related questions