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 you run with a
4-node configuration file, which two changes could improve sort performance in this scenario?
(Choose 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