SnowPro Advanced: Data Engineer — Question 100
How are overlapping columns handled when joining DataFrames in Snowpark?
Answer options
- A. Snowpark will return a join result containing multiple columns that have the same names.
- B. Snowpark will return the error: 'Ambiguous column'.
- C. Snowpark will prepend a randomly-generated prefix to the overlapping columns in the join result.
- D. Snowpark will append the DataFrame names to new columns in the join result.
Correct answer: B
Explanation
The correct answer is B because Snowpark cannot determine which overlapping column to reference, leading to an 'Ambiguous column' error. Option A is incorrect as it suggests that multiple columns with the same name would be returned, which is not permitted. Options C and D are also incorrect because Snowpark does not modify the names of overlapping columns in the join result.