exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 286 discussion

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

Which cache type is used to cache data output from SQL queries?

  • A. Metadata cache
  • B. Result cache
  • C. Remote cache
  • D. Local file cache
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
Kate0204
Highly Voted 2 years, 4 months ago
Result Cache:  Which holds the results of every query executed in the past 24 hours. These are available across virtual warehouses, so query results returned to one user is available to any other user on the system who executes the same query, provided the underlying data has not changed. Local Disk Cache:  Which is used to cache data used by SQL queries. Whenever data is needed for a given query it's retrieved from the Remote Disk storage, and cached in SSD and memory.
upvoted 11 times
shyemko
2 years ago
Result Query is stored at Cloud Service layer
upvoted 2 times
...
...
37ceea2
Most Recent 2 months, 3 weeks ago
Selected Answer: D
I am looking what Kate 02024 wrote. I am seeing that the question is about SQL queries, in this case, answer is D.
upvoted 1 times
...
Mallikharjuna452
9 months ago
Results cache
upvoted 2 times
...
_yyukta
1 year, 1 month ago
Selected Answer: B
B. Result cache
upvoted 1 times
...
Marge23
1 year, 7 months ago
Selected Answer: B
result cache
upvoted 1 times
...
MultiCloudIronMan
1 year, 9 months ago
Selected Answer: B
Correct
upvoted 1 times
...
EmiB
2 years, 1 month ago
Selected Answer: B
B is correct
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