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 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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Kate0204
Highly Voted 1 year, 11 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 10 times
shyemko
1 year, 7 months ago
Result Query is stored at Cloud Service layer
upvoted 1 times
...
...
Mallikharjuna452
Most Recent 3 months, 4 weeks ago
Results cache
upvoted 1 times
...
_yyukta
8 months, 3 weeks ago
Selected Answer: B
B. Result cache
upvoted 1 times
...
Marge23
1 year, 2 months ago
Selected Answer: B
result cache
upvoted 1 times
...
MultiCloudIronMan
1 year, 4 months ago
Selected Answer: B
Correct
upvoted 1 times
...
EmiB
1 year, 8 months 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 ...