Exam SnowPro Core topic 1 question 1337 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 1337
Topic #: 1

[All SnowPro Core Questions]

How can a relational table be unloaded into a JSON file?

A. Use the OBJECT_CONSTRUCT function in conjunction with the COPY INTO [location] command.
B. Use the COPY INTO [location] command with the file_format set as JSON.
C. Use the PUT command with the file_format set as JSON.
D. Use the GET command with the file_format set as JSON.

Show Suggested Answer

Suggested Answer: A 🗳️

by Mohit78jain at Jan. 9, 2025, 6:21 p.m.

Comments

Submit Cancel

t945123456

4 months ago

Selected Answer: A

Unloading a relational table to JSON You can use the OBJECT_CONSTRUCT function combined with the COPY command to convert the rows in a relational table to a single VARIANT column and unload the rows into a file. https://docs.snowflake.com/en/user-guide/data-unload-considerations

upvoted 1 times

...

37ceea2

4 months, 1 week ago

Selected Answer: B

The question does not say anything about an Object_Construct. Right answer is B.

upvoted 2 times

...

37ceea2

5 months ago

Selected Answer: A

-- Unload the data to a file in a stage COPY INTO @mystage FROM (SELECT OBJECT_CONSTRUCT('id', id, 'first_name', first_name, 'last_name', last_name, 'city', city, 'state', state) FROM mytable) FILE_FORMAT = (TYPE = JSON); -- The COPY INTO location statement creates a file named data_0_0_0.json.gz in the stage.

upvoted 2 times