exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1345 discussion

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

Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Choose two.)

  • A. A column that appears most frequently in ORDER BY operations
  • B. A column that appears most frequently in WHERE operations
  • C. A column that appears most frequently in GROUP BY operations
  • D. A column that appears most frequently in AGGREGATE operations
  • E. A column that appears most frequently in JOIN operations
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️

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
ywan1600
1 month, 2 weeks ago
Selected Answer: BE
While ORDER BY (A) and GROUP BY (C) operations can sometimes benefit from clustering, the most significant improvements are generally seen with WHERE and JOIN operations. AGGREGATE (D) operations are not as directly impacted by clustering as the other two.
upvoted 1 times
...
ViniJsr
1 month, 4 weeks ago
Selected Answer: AE
https://docs.snowflake.com/en/user-guide/tables-clustering-keys
upvoted 1 times
...
9df430d
2 months ago
Selected Answer: BC
The clustering key help filtering and grouping.
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago