SnowPro Core Certification — Question 1138

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

Answer options

• A. PARSE_JSON
• B. FLATTEN
• C. OBJECT_CONSTRUCT
• D. OBJECT_AGG

Correct answer: B

Explanation

The FLATTEN function is used to convert semi-structured data into a relational format by breaking down nested structures into a flat representation. PARSE_JSON and the OBJECT functions serve different purposes, such as parsing JSON strings and constructing or aggregating objects, but they do not specifically flatten data for relational use.