Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows Into a file in JSON format? (Select TWO).
PUT
GET
COPY
EXPORT
OBJECT CONSTRUCT
To convert rows in a relational table to a single VARIANT column and unload the rows into a file in JSON format, you can use the COPY command in combination with the OBJECT_CONSTRUCT function. The OBJECT_CONSTRUCT function converts the row into a JSON object stored in a VARIANT column, and the COPY command can then be used to unload this data into a JSON file.
References:
Snowflake Documentation: OBJECT_CONSTRUCT
Snowflake Documentation: COPY INTO
Top of Form
Bottom of Form
Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Select TWO.)
A column that appears most frequently in order by operations
A column that appears most frequently in where operations
A column that appears most frequently in group by operations
A column that appears most frequently in aggregate operations
A column that appears most frequently in join operations
What is the purpose of the use of the VALIDATE command?
To view any queries that encountered an error
To verify that a SELECT query will run without error
To prevent a put statement from running if an error occurs
To see all errors from a previously run COPY INTO