IBM
C2090-303 · Question #116
A job validates account numbers with a reference file using a Join stage, which is hash partitioned by account number. Runtime monitoring reveals that some partitions process many more rows than…
The correct answer is B. Change the number of nodes in the configuration file. See the full explanation below for the reasoning.
Question
A job validates account numbers with a reference file using a Join stage, which is hash partitioned by account number. Runtime monitoring reveals that some partitions process many more rows than others. Assuming adequate hardware resources, which action can be used to improve the performance of the job?
Options
- AReplace the Join with a Merge stage.
- BChange the number of nodes in the configuration file.
- CAdd a Sort stage in front of the Join stage. Sort by account number.
- DUse Round Robin partitioning on the stream and Entire partitioning on the reference.
How the community answered
(25 responses)- A4% (1)
- B84% (21)
- C4% (1)
- D8% (2)
Community Discussion
No community discussion yet for this question.