IBM SPSS Statistics Level 1 v2 — Question 19

Which of the following is TRUE about Transformer Stage when $APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set?

Answer options

• A. A Modify Operator is inserted at run time before a Transformer stage to handle null values
• B. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column contains a null.
• C. If an input column that is used in the derivation expression of an output column contains a null value, then that row will be dropped or, if a reject link had been defined, rejected
• D. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column will be calculated

Correct answer: C

Explanation

The correct answer is C because when $APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set, rows with null values in the derivation expression will be excluded or sent to a reject link if defined. Options A and D are incorrect as they misrepresent how null values are handled in this context, and option B does not accurately describe the behavior of the Transformer Stage under the given setting.