Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A user is unloading data to a stage using this command:
COPY INTO @message
FROM (SELECT OBJECT_CONSTRUCT('id', 1, 'first_name', 'Snowflake', 'last_name', 'User', 'city', 'Bozeman'))
FILE_FORMAT = (TYPE = JSON)
COPY INTO @message
FROM (SELECT OBJECT_CONSTRUCT('id', 1, 'first_name', 'Snowflake', 'last_name', 'User', 'city', 'Bozeman'))
FILE_FORMAT = (TYPE = JSON)
What will the output file in the stage contain?
A
A single compressed JSON file with a single VARIANT column
B
Multiple compressed JSON files with a single VARIANT column
C
A single uncompressed JSON file with multiple VARIANT columns
D
Multiple uncompressed JSON files with multiple VARIANT columns