SnowPro Core Certification — Question 695

What is the purpose of the Snowflake SPLIT_TO_TABLE function?

Answer options

• A. To count the number of characters in a string
• B. To split a string into an array of sub-strings
• C. To split a string and flatten the results into rows
• D. To split a string and flatten the results into columns

Correct answer: C

Explanation

The correct answer is C because the SPLIT_TO_TABLE function is specifically designed to take a string and produce a set of rows from its sub-strings. Option A is incorrect as it refers to character counting, while B describes splitting into an array, and D incorrectly suggests the results are organized into columns instead of rows.