Exam SnowPro Core topic 1 question 89 discussion

C

You can pass structured ARRAYs, structured OBJECTs, and MAPs to the FLATTEN function. https://docs.snowflake.com/en/sql-reference/data-types-structured#label-structured-types-working-flatten FLATTEN can be used to convert semi-structured data to a relational representation. https://docs.snowflake.com/en/sql-reference/functions/flatten So the answer is C. Both of the above

The main purpose of FLATTEN is to Un-nest the semistructured data like JSON.

It works for both

Works with both

C is correct, see https://docs.snowflake.com/en/sql-reference/data-types-structured#label-structured-types-working-flatten

Correct

B is correct

B is correct

Correct answer FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by definition it shouldn't be nested.