SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ49

VerifiedDesign and Manage Snowflake Resources and Performance

A Data Engineer runs a complex query and wants to use Snowflake’s query-results caching capability to reuse its results.

Which conditions must be satisfied?

Choose three
Explanation

Snowflake can reuse a persisted query result only when the new query exactly matches the prior query, the contributing table data/structure has not changed, and the table’s micro-partitions have not changed because of changes to other data in that table. Result reuse is enabled by default through the USE_CACHED_RESULT session parameter and does not require the same virtual warehouse.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!