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 316 discussion

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

Which of the following conditions must be met in order to return results from the results cache? (Choose two.)

  • A. The user has the appropriate privileges on the objects associated with the query.
  • B. Micro-partitions have been reclustered since the query was last run.
  • C. The new query is run using the same virtual warehouse as the previous query.
  • D. The query includes a User Defined Function (UDF).
  • E. The query has been run within 24 hours of the previously-run query.
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
by halol at Dec. 13, 2022, 6:51 a.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
halol
Highly Voted 1 year, 11 months ago
A&E as the below link: https://docs.snowflake.com/en/user-guide/querying-persisted-results.html#retrieval-optimization
upvoted 9 times
...
halol
Highly Voted 1 year, 11 months ago
E is correct and maybe A If the same query is fired again in 24 hrs, it will not be COMPUTED, which means it will not be charged. and it is not affected by WH suspension. So as the previous question the same exact query will return the pre-computed results if the underlying data hasn't changed and the results were last accessed within previous 24-hour period
upvoted 6 times
...
_yyukta
Most Recent 8 months, 3 weeks ago
Selected Answer: AE
AE are correct
upvoted 1 times
...
Avi0407
1 year ago
Selected Answer: CE
C&E having access on an object might not give the same results... need to revisit the answer ..
upvoted 1 times
...
examtopics_strata
1 year, 3 months ago
Selected Answer: AE
A and E correct
upvoted 1 times
...
MultiCloudIronMan
1 year, 3 months ago
Selected Answer: AE
correct
upvoted 1 times
...
c0d3g
1 year, 4 months ago
Selected Answer: AE
The user has the appropriate privileges on the objects associated with the query. The query has been run within 24 hours of the previously-run query.
upvoted 1 times
...
Hopefan
1 year, 8 months ago
how about C and E ?
upvoted 1 times
cctv
1 year, 3 months ago
it doesn't matter with the warehouse since the result cache returning is through cloud service layer.
upvoted 2 times
...
...
fahfouhi94
1 year, 9 months ago
Selected Answer: AE
A&E are the conditions
upvoted 3 times
...
AlexbDku
1 year, 10 months ago
Selected Answer: AE
Answer -- A&E
upvoted 1 times
...
arpit_dataguy
1 year, 10 months ago
Answer -- A&E
upvoted 3 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