Exam SnowPro Core topic 1 question 175 discussion

The output of Flatten: SEQ A unique sequence number associated with the input record; the sequence is not guaranteed to be gap-free or ordered in any particular way. KEY For maps or objects, this column contains the key to the exploded value. PATH The path to the element within a data structure which needs to be flattened. INDEX The index of the element, if it is an array; otherwise NULL. VALUE The value of the element of the flattened array/object. THIS The element being flattened (useful in recursive flattening).

PATH,INDEX

B and D are correct

https://docs.snowflake.com/en/sql-reference/functions/flatten#output

answer - BD In Snowflake, the LATERAL FLATTEN command is used to unnest semi-structured data stored in variant or object columns. When you execute the LATERAL FLATTEN command, it generates a new virtual table with the unnested data. The result set of the LATERAL FLATTEN command includes the following columns: KEY: This column contains the key or path to the unnested element within the original semi-structured data. INDEX: This column represents the index of the unnested element within the array or object. ELEMENT: This column contains the value of the unnested element. These three columns make up the result set of the LATERAL FLATTEN command and provide the necessary information to access and process the unnested data.

A. CONTENT and B. PATH. The LATERAL FLATTEN command expands a VARIANT, OBJECT, or ARRAY column into multiple rows, where CONTENT represents the expanded values and PATH represents the path to the expanded values within the original column. The columns C. BYTE_SIZE, D. INDEX, and E. DATATYPE are not part of the result set of the LATERAL FLATTEN command.

The result value of flatten command is SEQ, PATH, KEY, INDEX, VALUE, THIS

Was on exam Dec 31st 2022

https://docs.snowflake.com/en/sql-reference/functions/flatten.html

https://docs.snowflake.com/en/sql-reference/functions/flatten.html

https://docs.snowflake.com/en/sql-reference/functions/flatten.html