SnowPro Core Certification — Question 588

Which function will return a row for each for each object in a VARIANT, OBJECT, or ARRAY column?

Answer options

• A. CAST
• B. FLATTEN
• C. GET
• D. PARSE_JSON

Correct answer: B

Explanation

The correct answer is FLATTEN, as it is specifically designed to take nested structures in VARIANT, OBJECT, or ARRAY columns and produce a separate row for each item. The other options, such as CAST, GET, and PARSE_JSON, do not provide this functionality for creating rows from nested objects.