SnowPro Advanced: Architect — Question 149

An account has default settings for all parameters set. The MERGE command is used to update or delete target rows that join multiple source rows.

What will be the outcome of the MERGE statement?

Answer options

• A. An error will be returned that includes values from one of the target rows that caused the error.
• B. The merge will complete successfully, and the results of the merge will be nondeterministic.
• C. The merge will be performed based on the first match of the multiple source rows with the target row.
• D. The merge will be performed based on the last match of the multiple source rows with the target row.

Correct answer: B

Explanation

The correct answer is B because when multiple source rows are involved, the behavior of the MERGE statement can lead to unpredictable results, especially when the target rows are updated. Options A, C, and D imply deterministic outcomes or errors which are not consistent with how the MERGE command functions under default settings.