Explanation:
The question requires converting relational table rows to a single VARIANT column and unloading them as JSON. OBJECT_CONSTRUCT is the correct function as it builds JSON objects from key-value pairs, creating VARIANT data. COPY is the correct command for unloading data to files, specifically supporting JSON format when used with FILE_FORMAT = (TYPE = 'JSON'). PUT is for uploading files to stages, GET is for downloading files, and EXPORT is not a valid Snowflake command for data unloading.
Which Snowflake function and command combination should be used to transform rows from a relational table into a single VARIANT column and then export those rows into a JSON file? (Choose two.)
A
PUT
B
GET
C
COPY
D
EXPORT
E
OBJECT_CONSTRUCT
No comments yet.