SnowPro Core Certification — Question 1078

Which function can be used to convert semi-structured data into rows and columns?

Answer options

• A. TABLE
• B. FLATTEN
• C. PARSE_JSON
• D. JSON_EXTRACT_PATH_TEXT

Correct answer: B

Explanation

The FLATTEN function is specifically designed to convert semi-structured data into a more structured format, allowing it to be represented as rows and columns. The TABLE function does not perform this conversion, while PARSE_JSON and JSON_EXTRACT_PATH_TEXT are used for parsing JSON data but do not directly convert it into a tabular format.