A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database. For this warehouse, why should the Administrator…

Question

Options

• ATo save costs on warehouse shutdowns and startups for different queries
• BTo save costs by running the warehouse as little as possible
• CTo keep the data cache warm to support good performance of similar queries
• DTo keep the query result cache warm for good performance on repeated queries

• A
  5% (1)
• B
  5% (1)
• C
  81% (17)
• D
  10% (2)

Explanation

The AUTO_SUSPEND property specifies the number of seconds of inactivity after which a warehouse is automatically suspended. If the property is set to 0 or NULL, the warehouse never suspends automatically. For a warehouse that supports several dashboards, issuing various queries on the same database, setting AUTO_SUSPEND to 0 or NULL can help to keep the data cache warm, which means that the data used by the queries is already loaded into the warehouse memory and does not need to be fetched from the storage layer. This can improve the performance of similar queries that access the same data.

No community discussion yet for this question.