🔥 3-day streak
Snowflake SnowPro Core (COF-C03)78 / 148
Question 78 of 148

A data analyst runs an ad hoc analytics workload on a MEDIUM warehouse. Most queries complete quickly, but a few unpredictable, scan-heavy queries take far longer because they process large amounts of data. The team does not want to permanently resize the warehouse, since that would raise costs for the many small queries. The Query Profile for the slow queries shows most time spent in TableScan operations with no significant spillage. Which Snowflake feature best addresses these occasional large scan-heavy outlier queries without increasing the base warehouse size?

Reviewed for accuracy · Report an issueNext question