C2090-013 Online Practice Questions and Answers

Given the Type node shown below,

what specifications are necessary to change all values outside the range 1 to 15 in field dropped_calls to the undefined ($null$) value?

A. Pass Values and Check action Nullify

B. Specify Values Lower 1 and Upper 15 and Check action Nullify

C. Specify Values Lower 1 and Upper 15 and Check action Discard

D. Read Values and Check action Warn

Examine the Data Audit output shown below.

What action will occur in a generated Outlier and Extreme Supernode for HOLCOST?

A. Nine records will be set to the system missing (null) value for HOLCOST.

B. Ten records will be deleted.

C. Ten records will be set to the system missing (null) value for HOLCOST.

D. Nine records will be deleted.

Which node can be used to easily generate a field that divides the data into subsamples for the Training and Testing stages of modeling?

A. Sample

B. Filler

C. Balance

D. Partition

Which fields are created by this Derive dialog?

A. Three fields representing the difference between Travel-1 and each of the other Travel fields

B. No operation will be performed because the expression is invalid.

C. Four fields representing the difference in weeks between AcctEst and each of the Travel fields

D. A field representing the difference between AcctEst and the global @FIELD value

True or false: running Auto Dataprep results in data transformation nodes placed in a Supernode on the canvas.

A. True

B. False

Which node can be used to impute (estimate) missing values?

A. Data Audit node

B. Balance node

C. Filler node D. Reclassify node

Which of the following types of nodes will have data flowing both in and out, when used in a stream?

A. Record Ops

B. Graphs

C. Export

D. Sources

True or false: the optimal binning method in the Binning node uses a Supervisor field to determine the binning cut points.

A. True

B. False

True or false: only Terminal nodes (Graphs, Modeling, Output, Export) have a Run button as displayed in the graphic.

A. True

B. False

Which method would be used on the Merge node in order to combine a file containing 100 products and a file containing 50 suppliers and retain only the matching records?

A. Inner join

B. Anti-join

C. Full outer join

D. Partial outer join

To correctly read the Excel? file shown below,

which dialog box settings are appropriate?

A.

B.

C.

D.

Which node is used to read data from a comma delimited text file?

A. Var. File

B. Data Collection

C. Fixed File

D. Statistics File

True or false: IBM SPSS Modeler builds a new model when a new data set is passed through a Model Nugget.

A. True

B. False

True or false: the Feature Selection node adds a Model Nugget to the stream.

A. True

B. False

A prison system has historical data on prison inmates and wants to find what factors are related to recidivism (return to prison). What type of model would be used?

A. Segmentation model

B. Classification model

C. Association model

D. Anomaly model