Online Access Free C2020-012 Practice Test

Auto checking for invalid values can be done on the Type tab in any Source node.

• A.False
• B.True

The SetToFlag node creates separate flag fields for values of a categorical field. It must be followed by an Aggregate node in order to aggregate the flag fields on a grouping field such as transaction records grouped to customer's records.

• A.False
• B.True

Examine the Data Audit output shown below.

What action will occur in a generated Outlier & Extreme Super node for HOLCOST?

• A.Nine records will be deleted
• B.Ten records will be deleted.
• C.Nine records will be set to the system missing (null) value for HOLCOST.
• D.Ten records will be set to the system missing (null) value for HOLCOST.

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.Partial outer join
• C.Full outer join
• D.Anti-join