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

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

View Answer

Answer: B

Explanation:

The Result cache is used in Snowflake to cache the data output from SQL queries. This feature is designed to improve performance by storing the results of queries for a period of time. When the same or similar query is executed again, Snowflake can retrieve the result from this cache instead of re-computing the result, which saves time and computational resources.

Reference: Snowflake Documentation on Query Results Cache

SnowPro® Core Certification Study Guide