IBM SPSS Statistics Level 1 v2 — Question 37

A job consist of Sequential File Stage -> Copy Stage using auto partitioning -> Sequential File stage. We need the target Sequential File stage rows to be in the same order as the source file. Which collection algorithm should be chosen in the target Sequential File stage?

Answer options

• A. Auto
• B. Same
• C. Round robin
• D. Sorted merge

Correct answer: D

Explanation

The correct answer is D, Sorted merge, as it ensures that the data is collected in a sorted manner, preserving the order from the source. Options A (Auto) and C (Round robin) do not guarantee row order, and B (Same) is not applicable in this context since it does not refer to the required collection method for maintaining order.