Result caching layers in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is result caching in Snowflake?

Result caching in Snowflake stores the results of a query so that if the same query is run again, Snowflake can return the stored results instantly without re-executing the query.

beginner

How long does Snowflake keep query results in the result cache?

Snowflake keeps query results in the result cache for 24 hours, as long as the underlying data has not changed.

intermediate

What conditions must be met for Snowflake to use the result cache for a query?

The query text must be exactly the same, the underlying data must not have changed, and the user must have the same access rights.

beginner

What is the benefit of result caching in Snowflake?

It reduces query execution time and saves compute resources by returning stored results instantly instead of running the query again.

intermediate

Can result caching be disabled in Snowflake?

Yes, result caching can be disabled by setting the parameter USE_CACHED_RESULT to FALSE in the query.

How long does Snowflake keep query results in the result cache?

A 7 days

B 1 hour

C 24 hours

D Until the warehouse is restarted

Snowflake keeps query results in the result cache for 24 hours if the underlying data remains unchanged.

Which of the following is NOT a requirement for Snowflake to use the result cache?

A Underlying data must not have changed

B Warehouse must be running on the same server

C User must have the same access rights

D Query text must be exactly the same

Snowflake's result cache is independent of the warehouse server location.

What happens if the underlying data changes after a query is cached?

A Snowflake ignores the cache and reruns the query

B Snowflake returns the cached result anyway

C Snowflake deletes the cache but returns old results

D Snowflake pauses the query

If data changes, Snowflake invalidates the cache and reruns the query to get fresh results.

How can you disable result caching for a specific query in Snowflake?

A Set USE_CACHED_RESULT = FALSE

B Set CACHE_ENABLED = FALSE

C Use NO_CACHE keyword

D Result caching cannot be disabled

You can disable result caching by setting USE_CACHED_RESULT = FALSE in the query.

What is the main benefit of using result caching in Snowflake?

A Automatically backs up data

B Increases storage space

C Allows multiple users to edit data simultaneously

D Improves query speed and saves compute resources

Result caching speeds up queries and reduces compute costs by reusing previous results.

Explain how Snowflake's result caching works and when it is used.

Think about what must stay the same for cache to be used.

Describe how to disable result caching for a query in Snowflake and why you might want to do that.

Consider scenarios needing fresh data always.