Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 840

What does the LATERAL modifier for the FLATTEN function do?

Casts the values of the flattened data

Extracts the path of the flattened data

Joins information outside the object with the flattened data

Retrieves a single instance of a repeating element in the flattened data

Correct Answer: C

The LATERAL modifier for the FLATTEN function in SQL is used to join information outside the object with the flattened data. This allows you to combine external data with the results of the FLATTEN function, making it possible to work with arrays and other nested data structures in a more integrated manner.

Discussion

BobFarOption: C

C. is correct Joins information outside the object with the flattened data https://docs.snowflake.com/en/user-guide/querying-semistructured#using-the-flatten-function-to-parse-arrays

HeetecOption: C

C correct - https://docs.snowflake.com/en/user-guide/querying-semistructured