IBM
C2090-303 · Question #34
A 100MB input dataset has even distribution across 400 unique key values. When you run with a 4-node configuration file, which two changes could improve sort performance in this scenario? (Choose…
The correct answer is B. Set $APT_TSORT_STRESS_BLOCKSIZE to 50MB. E. Specify "Restrict Memory Usage" to 60MB on the Sort stage properties. See the full explanation below for the reasoning.
Question
A 100MB input dataset has even distribution across 400 unique key values. When you run with a 4-node configuration file, which two changes could improve sort performance in this scenario? (Choose two.)
Options
- AConvert all numeric fields to varchars.
- BSet $APT_TSORT_STRESS_BLOCKSIZE to 50MB.
- CAlter the Sort stage properties to perform a stable sort.
- DSpecify Round Robin partitioning on the input link to the Sort stage.
- ESpecify "Restrict Memory Usage" to 60MB on the Sort stage properties.
How the community answered
(31 responses)- A10% (3)
- B84% (26)
- C3% (1)
- D3% (1)
Community Discussion
No community discussion yet for this question.