Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 966

Which function is used to convert rows in a relational table to a single VARIANT column?

    Correct Answer: A

    The function used to convert rows in a relational table to a single VARIANT column is ARRAY_AGG. ARRAY_AGG is an aggregation function that collects values from multiple rows into an array, which Snowflake then stores as a VARIANT data type. This allows the aggregation of row data into a single column with a VARIANT type.

Discussion
GwoOption: D

D is correct. https://docs.snowflake.com/en/user-guide/data-unload-considerations