IBM
C2090-303 · Question #68
C2090-303 Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-303 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
Question
A DataStage job uses an Inner Join to combine data from two source parallel datasets that were written to disk in sort order based on the join key columns. Which two methods could be used to dramatically improve performance of this job? (Choose two.)
Options
- ADisable job monitoring.
- BSet the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
- CUnset the Preserve Partitioning flag on the output of each parallel dataset.
- DExplicitly specify hash partitioning and sorting on each input to the Join stage.
- EAdd a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort
Unlock C2090-303 to see the answer
You've previewed enough free C2090-303 questions. Unlock C2090-303 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.