Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1006 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 1006
Topic #: 1
[All SnowPro Core Questions]

Which function can be used with the COPY INTO statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file?

  • A. FLATTEN
  • B. OBJECT_AS
  • C. OBJECT_CONSTRUCT
  • D. TO_VARIANT
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
d22770a
1 month ago
Selected Answer: C
OBJECT_CONSTRUCT: Converts the row into a JSON object stored in a VARIANT column.
upvoted 1 times
...
cybe001
5 months, 4 weeks ago
D is correct D. USAGE: The USAGE privilege on a database allows users to access objects within the database, which is necessary for the users who will be accessing the shared secure view. This privilege is required to ensure that users can resolve references to objects in the database when querying the secure view.
upvoted 1 times
...
tidz
9 months, 2 weeks ago
Selected Answer: C
Answer C
upvoted 1 times
...
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.

SaveCancel
Loading ...