Exam SnowPro Core topic 1 question 89 discussion

* Why is FLATTEN also used in Structured Types? : Because Snowflake's Structured Types (structured data) have internally nested complex structures, they are difficult to query directly using general SQL queries. : At this time, the FLATTEN function performs the following roles: - Convert nested structures into table form for easy search. - Internal composite elements (STRUCTURED ARRAY, STRUCTURED OBJECT, MAP internal elements) are expanded into separate rows to enable querying. In other words, the FLATTEN function is essential in Snowflake's Structured Types (explicitly structured complex data), not general table data.

there are 2 reason in snowflake document. 1) https://docs.snowflake.com/en/sql-reference/data-types-structured#label-structured-types-working-flatten --> Using the FLATTEN function with values of structured types --> You can pass structured ARRAY, structured OBJECT, and MAP values to the FLATTEN function. As is the case with semi-structured data types, you can use the PATH argument to specify the value being flattened. 2) https://docs.snowflake.com/en/sql-reference/functions/flatten#usage-notes --> FLATTEN is a table function that takes a VARIANT, OBJECT, or ARRAY column and produces a lateral view (i.e. an inline view that contains correlation referring to other tables that precede it in the FROM clause). --> FLATTEN can be used to convert semi-structured data to a relational representation.

Answer B The FLATTEN function in Snowflake is used to query and extract data from semi-structured data types, specifically: Arrays Objects (key-value pairs, such as those found in JSON data) The function expands these structures into a table-like format, allowing you to work with individual elements or key-value pairs in SQL queries.

Answer B

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.