ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 821 discussion

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

How does the PARTITION BY option affect an expression for a COPY INTO [location] command?

  • A. The unload operation partitions table rows into separate files unloaded to the specified table.
  • B. The unload operation partitions table rows into separate files unloaded to the specified stage.
  • C. A single file will be loaded with a user-defined partition key and the user can use this partition key for clustering.
  • D. A single file will be loaded with a Snowflake-defined partition key and Snowflake will use this key for pruning.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Heetec at Oct. 10, 2023, 8:47 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Gwo
9 months, 2 weeks ago
B. The PARTITION BY option in a COPY INTO command specifies an expression that partitions the unloaded table rows into separate files unloaded to the specified stage. The expression must be based on one or more columns in the table.
upvoted 2 times
...
kayuhanbiduk
1 year ago
Selected Answer: B
B correct
upvoted 1 times
...
Heetec
1 year, 1 month ago
Selected Answer: B
B correct - https://docs.snowflake.com/en/user-guide/data-unload-overview
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago