C2090-930 · Question #23
You are hired by a large corporation to perform advanced analytics on their human resources data. One of the fields available in this data set is employee salary. You need to convert raw salary…
The correct answer is D. Distinct node. There appears to be an error in the stated correct answer. Based on standard data analytics tools (such as IBM SPSS Modeler), A (Binning node) is the correct answer for this task - not D. Why A (Binning node) is correct: The Binning node converts continuous numeric fields (like…
Question
You are hired by a large corporation to perform advanced analytics on their human resources data. One of the fields available in this data set is employee salary. You need to convert raw salary information into percentile rankings within the corporation. Which node will you use to accomplish this task?
Options
- ABinning node
- BField Reorder node
- CPartition node
- DDistinct node
How the community answered
(36 responses)- A14% (5)
- B8% (3)
- C6% (2)
- D72% (26)
Explanation
There appears to be an error in the stated correct answer. Based on standard data analytics tools (such as IBM SPSS Modeler), A (Binning node) is the correct answer for this task - not D.
Why A (Binning node) is correct: The Binning node converts continuous numeric fields (like salary) into ranked categories or percentiles. It specifically includes a percentile/rank option that converts raw values into their percentile position within the dataset, which is exactly what the question describes.
Why the distractors are wrong:
- B (Field Reorder node): Simply changes the display order of columns in the dataset - no calculations involved.
- C (Partition node): Splits data into training, testing, and validation subsets for model building - unrelated to ranking.
- D (Distinct node): Identifies or removes duplicate records - it has no functionality for percentile or rank calculations.
Memory tip: Think "Bins = Buckets = Rankings." The Binning node buckets continuous values into groups - and percentile ranking is just a special kind of bucketing where each bucket represents a percentile position.
Recommendation: Double-check the source of this question. If it came from a study guide or practice exam, D may be a typo or error. If this is from an official certification exam, the answer key itself may contain a mistake - which does happen. I'd verify against official IBM SPSS Modeler documentation before accepting D as correct.
Topics
Community Discussion
No community discussion yet for this question.