There are two database tables which contain data that is needed for analysis. One table contains information pertaining to customer names, customer IDs. and their age. The other table contains…

Question

Options

• AMerge node
• BAppend node
• CDerive node
• DType node

• A
  2% (1)
• B
  2% (1)
• C
  92% (54)
• D
  5% (3)

Explanation

Note: There appears to be an error in the provided answer key. The correct answer for this question is A (Merge node), not C.

A Merge node combines two or more datasets horizontally by matching records on a common key field - exactly what's needed here, since both tables share a customer ID that links customer demographic data to address data.

Why the distractors are wrong:

• B (Append node): Stacks datasets vertically by adding rows, not joining columns - used when both tables have the same structure.
• C (Derive node): Creates new calculated or conditional fields from existing data within a single dataset; it cannot join two separate tables.
• D (Type node): Defines metadata like data types, roles, and measurement levels - it reads data, not combines it.

Memory tip: Think "Merge = marriage" - two separate datasets come together as one by matching on a shared key (like customer ID), just as two families join through a common bond.

If this is from an IBM SPSS Modeler exam, the Merge node is the well-established correct answer for this scenario. Double-check your source material, as answer key typos do occur.

No community discussion yet for this question.