SnowPro Core Certification — Question 685

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)

What will the output file in the stage be?

Answer options

• 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

Correct answer: A

Explanation

The command provided is designed to create a single output file in JSON format, which will be compressed by default. Since it constructs a single JSON object using the object_construct function, it results in one VARIANT column, making option A the correct answer. The other options incorrectly suggest multiple files or uncompressed files, which do not align with the command's behavior.