In the described dataflow scenario, which step generates the two columns OrderDateTime.1 and OrderDateTime.2?

• A. Split Column by position
• B. Split Column by delimiter
• C. Extract Text After Delimiter
• D. Change Type

Answer: (A)

The step being tested is splitting a single column into fixed parts based on character positions. When you split by position, you define exact cut points in the string and the tool creates separate output columns for each piece, automatically naming them by appending .1, .2, and so on to the original column name. That’s why you get OrderDateTime.1 and OrderDateTime.2—the two pieces of the original value.

Splitting by delimiter would also break the text into pieces, but it uses a specific separator character to decide where to split, and the naming behavior can differ depending on the delimiter and tool settings. Extract Text After Delimiter would yield only one column containing the portion after the delimiter, not two columns. Change Type simply changes how the existing data is typed and does not create new columns.