ExamGecko
Question list
Search
Search

Question 5 - SnowPro Core discussion

Report
Export

Will data cached in a warehouse be lost when the warehouse is resized?

A.
Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
Answers
A.
Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
B.
Yes. because the compute resource is replaced in its entirety with a new compute resource.
Answers
B.
Yes. because the compute resource is replaced in its entirety with a new compute resource.
C.
No. because the size of the cache is independent from the warehouse size
Answers
C.
No. because the size of the cache is independent from the warehouse size
D.
Yes. became the new compute resource will no longer have access to the cache encryption key
Answers
D.
Yes. became the new compute resource will no longer have access to the cache encryption key
Suggested answer: C

Explanation:

When a Snowflake virtual warehouse is resized, the data cached in the warehouse is not lost. This is because the cache is maintained independently of the warehouse size. Resizing a warehouse, whether scaling up or down, does not affect the cached data, ensuring that query performance is not impacted by such changes.

[COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Virtual Warehouse Performance1

asked 23/09/2024
Lukasz Malaczek
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first