PrepAway - Latest Free Exam Questions & Answers

which two changes could improve sort performance in this scenario?

A 100MB input dataset has even distribution across 400 unique key values.
When run with a 4-node configuration file, which two changes could improve sort performance in
this scenario? (Select two)

PrepAway - Latest Free Exam Questions & Answers

A.
Convert all numeric fields to varchars.

B.
Set $APT_TSORT_STRESS_BLOCKSIZE to 50MB.

C.
Alter the Sort stage properties to perform a stable sort.

D.
Specify Round Robin partitioning on the input link to the Sort stage.

E.
Specify “Restrict Memory Usage” to 60MB on the Sort stage properties.

Explanation:


Leave a Reply