No, D is not correct. As long as Variant column is not part of the action, it is about TO_JSON, since, we do not need to construct any object, like Variant column.
D is correct:
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
d is correct: https://community.snowflake.com/s/article/faq-can-i-unload-a-relational-table-with-multiple-columns-to-json
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
37ceea2
2 weeks, 1 day agoAparna98
4 months, 3 weeks agonexerSnow
5 months ago4762448
5 months, 1 week agoicegrandpa
5 months, 2 weeks ago