ADA-C02: SnowPro Advanced — Administrator

By Snowflake · Question Mode

QuestionQ34

VerifiedManage and maintain database objects and virtual warehouses

A Snowflake Administrator needs to create a virtual warehouse that supports several dashboards running various queries against the same database.

Why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL for this warehouse?

Explanation

A running virtual warehouse maintains a local cache of table data accessed by its queries. Preventing automatic suspension preserves that data cache, improving performance for similar dashboard queries against the same database. The query result cache is not warehouse-local, so keeping the warehouse running does not keep it warm. Snowflake documents that AUTO_SUSPEND set to 0 or NULL means the warehouse never suspends.

Learn more

Community Discussion

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