COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ20

Performance Optimization, Querying & Transformation

A reporting dashboard uses a dedicated warehouse that automatically suspends after five minutes of inactivity. Comparable queries run intermittently, with intervals longer than five minutes. Users observe that the first query after suspension takes substantially longer than later queries while the warehouse remains active.

How can query performance be improved?

Explanation

Suspending a Snowflake warehouse drops its local data cache, so the first query after automatic resumption can be slower while the cache is rebuilt. Increasing the AUTO_SUSPEND interval can keep the warehouse active across intermittent, similar dashboard queries and preserve the cache, improving subsequent query latency. Optimizing the warehouse cache

Learn more

Community Discussion

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