SnowPro Core Certification — Question 1277

How should the SPLIT_TO_TABLE([string], [delimiter]) function be called?

Answer options

• A. SELECT SPLIT_TO_TABLE(COL1, '.') FROM DUAL;
• B. SELECT SPLIT_TO_TABLE('a.b.c', '.');
• C. SELECT * FROM TABLE(SPLIT_TO_TABLE('a.b.c', '.'));
• D. SELECT * FROM SPLIT_TO_TABLE('a.b.c', '.');

Correct answer: C

Explanation

The correct answer is C because the SPLIT_TO_TABLE function needs to be called within the TABLE() function to return a result set. Options A and B do not return a table format, and option D incorrectly attempts to select directly from the function without the TABLE wrapper.