nerdexam
IBM

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…

Data Preparation

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)
  • A
    14% (5)
  • B
    8% (3)
  • C
    6% (2)
  • D
    72% (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

#data transformation#percentile ranking#field derivation#salary data

Community Discussion

No community discussion yet for this question.

Full C2090-930 Practice