nerdexam
IBM

C2090-930 · Question #16

Which two types of missing values are automatically recognized by IBM SPSS Modeler Professional without being explicitly defined by users? (Choose two.)

The correct answer is B. String with value "%NULL%" D. Numeric set to NaN. IBM SPSS Modeler Professional has two built-in missing value tokens it recognizes automatically: the string literal %NULL% (option B), which acts as a reserved placeholder Modeler treats as missing for string fields without any user configuration, and NaN (Not a Number, option…

Data Preparation

Question

Which two types of missing values are automatically recognized by IBM SPSS Modeler Professional without being explicitly defined by users? (Choose two.)

Options

  • ANull or system-missing values
  • BString with value "%NULL%"
  • CBlank missing values
  • DNumeric set to NaN

How the community answered

(49 responses)
  • A
    8% (4)
  • B
    88% (43)
  • C
    4% (2)

Explanation

IBM SPSS Modeler Professional has two built-in missing value tokens it recognizes automatically: the string literal %NULL% (option B), which acts as a reserved placeholder Modeler treats as missing for string fields without any user configuration, and NaN (Not a Number, option D), which is the standard IEEE floating-point representation of an undefined numeric result and is recognized automatically for numeric fields.

Options A and C are incorrect because they require explicit user action - null/system-missing values (A) depend on how a data source is configured or imported (e.g., from SPSS Statistics files), and blank missing values (C) must be manually declared as missing in the Type node or source settings; a blank string is not treated as missing by default.

Memory tip: Think of it as Modeler having two "secret codes" baked in - %NULL% for strings and NaN for numbers. Anything else (blanks, system-missing) requires you to tell Modeler it's missing.

Topics

#missing values#null values#NaN#system-missing

Community Discussion

No community discussion yet for this question.

Full C2090-930 Practice