The correct answer is D. When the system estimates that there is enough query load to keep the new cluster busy for at least 6 minutes .
In Snowflake, a multi-cluster warehouse can use either a Standard or Economy scaling policy. The Economy scaling policy is more conservative. It starts additional clusters only when Snowflake estimates that the extra cluster will have enough work to justify the additional compute cost.
Why D is correct:
With the Economy scaling policy, Snowflake starts another cluster only if the system estimates there is enough query load to keep the new cluster busy for approximately 6 minutes. This helps reduce credit consumption by avoiding unnecessary short-lived cluster starts.
Why the other options are incorrect:
A). The condition is not based on all active clusters running queries for more than 6 minutes.
B). A single queued query for more than 6 minutes is not the exact Economy scaling rule.
C). The rule is not specifically based on 3 or more queued queries.
D). This matches Snowflake's documented behavior for the Economy scaling policy.
Official Snowflake documentation reference:
Snowflake documentation explains that the Economy scaling policy conserves credits by starting additional clusters only when Snowflake estimates enough query load exists to keep the cluster busy for at least 6 minutes.
Reference: Snowflake Documentation - Multi-cluster warehouses; Snowflake Documentation - Scaling policy; SnowPro Core Study Guide - Virtual Warehouses and Resource Management.
==

In a Query Profile, the statistical information that indicates a query is too large to fit in memory includes bytes spilled to local cache and bytes spilled to local storage. These metrics suggest thatthe working data set of the query exceeded the memory available on the warehouse nodes, causing intermediate results to be written to disk

TheGET_PRESIGNED_URLfunction in Snowflake generates a pre-signed URL for a file in an internal stage.
This URL can be shared with external tools or users who do not have direct access to Snowflake, allowing them to download the file.
Generate Pre-Signed URL:
SELECT GET_PRESIGNED_URL(@my_stage/file.txt);
Share the URL:The generated URL can be shared with external users or applications, enabling them to access the file directly.
References:
Snowflake Documentation: GET_PRESIGNED_URL
Snowflake Documentation: Working with Stages

The correct answer is C. Pre-signed URL .
Corrected wording:
The option listed as "re-signed URL" appears to be a typing error. The correct term is "pre-signed URL." A pre-signed URL provides temporary access to a file in cloud storage. It is commonly used when a user or application needs time-limited access to a staged file without granting broader permissions to the underlying storage location.
Why C is correct:
A pre-signed URL includes authorization information and is valid only for a defined period of time. This makes it appropriate when users need a limited access window.
Example concept:
SELECT GET_PRESIGNED_URL(@my_stage, ' path/file.csv ' , 3600);
This returns a URL that allows access to the staged file for a limited duration, such as 3600 seconds.
Why the other options are incorrect:
A). A scoped URL is encoded and scoped to a query result context. It is useful for controlled access through Snowflake, but the option that directly provides a time-limited access window to cloud storage is a pre-signed URL.
B). A file URL identifies a file location, but it does not itself provide temporary authorized access.
D). Redirect URL is not the Snowflake file access URL type used for this requirement.
Official Snowflake documentation reference:
Snowflake documentation describes GET_PRESIGNED_URL as a function that returns a pre-signed URL to a staged file, allowing temporary access for a specified expiration time.
Reference: Snowflake Documentation - GET_PRESIGNED_URL; Snowflake Documentation - File functions; SnowPro Core Study Guide - Data Loading and Unloading.
==