SnowPro Core Certification — Question 1153

In a SPLIT_PART function, what will the returned value be if the partNumber is out of range?

Answer options

• A. −1
• B. An empty string
• C. The full string
• D. An error

Correct answer: B

Explanation

When the partNumber is out of range in the SPLIT_PART function, it returns an empty string, indicating that there is no valid part to return. The other options are incorrect as −1 is not a valid return value, the full string is returned only when partNumber is 1, and an error is not thrown for out-of-range requests.