
Answer-first summary for fast verification
Answer: COPY, OBJECT_CONSTRUCT
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.