SnowPro Core Certification — Question 267

Which TABLE function helps to convert semi-structured data to a relational representation?

Answer options

• A. CHECK_JSON
• B. TO_JSON
• C. FLATTEN
• D. PARSE_JSON

Correct answer: C

Explanation

The FLATTEN function is specifically designed to handle semi-structured data, allowing it to be converted into a tabular format suitable for relational databases. The other options, such as CHECK_JSON and PARSE_JSON, are related to JSON validation and parsing but do not directly convert data into a relational representation, while TO_JSON is used for converting relational data into JSON format.