True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

The statement is correct. Snowflake's architecture is designed with three distinct layers: storage, compute (virtual warehouses), and cloud services. The query result cache is a component of the Cloud Services layer. When a user submits a query that is an exact match to a previously executed query, and the underlying data has not changed, Snowflake can retrieve the results directly from this cache. This operation is handled by the Cloud Services layer and does not require an active (i.e., running or resumed) virtual warehouse, thereby consuming no compute credits and returning results almost instantaneously.

The option "False" is incorrect because it contradicts a fundamental architectural feature and benefit of Snowflake. If an active warehouse were required to access the result cache, one of the primary advantages of this feature—avoiding compute costs for repeated queries—would be eliminated. The separation of the Cloud Services layer (which manages the cache) from the Virtual Warehouse (compute) layer is what makes this cost-saving functionality possible.

1. Snowflake Documentation: Using the Result Cache.

Section: "Result Cache Benefits"

Quote: "When a query result is retrieved from the cache, the query is not re-executed and a virtual warehouse is not used. As a result, the query completes almost instantaneously and consumes no credits."

Reference: Snowflake Documentation: Using the Result Cache

2. Snowflake Documentation: Overview of the Snowflake Architecture.

Section: "Cloud Services"

Quote: "This layer also stores the results of queries. For a period of 24 hours, the results of a query are available. If the same query is re-issued by the same user or by a different user on the same account, and if the underlying data has not changed, Snowflake returns the cached result set. This feature does not require a virtual warehouse and reduces query time and processing."

Reference: Snowflake Documentation: Overview of the Snowflake Architecture