Snowflake
SOL-C01 · Question #261
A Snowflake user reports that their worksheet intermittently freezes or becomes unresponsive when executing complex SQL queries that involve large datasets. Which of the following actions could potent
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #261. The question stem and answer options stay visible for context.
Querying and Performance
Question
A Snowflake user reports that their worksheet intermittently freezes or becomes unresponsive when executing complex SQL queries that involve large datasets. Which of the following actions could potentially improve the performance and responsiveness of the Snowflake worksheet?
Options
- AIncrease the number of concurrent queries allowed for the user's role.
- BChange the worksheet's preferred warehouse to a larger size (e.g., from X-Small to Large) with
- CEnable result caching for the worksheet session using 'ALTER SESSION SET USE CACHED
- DSplit the complex query into smaller, more manageable queries and execute them sequentially.
- EIncrease the timeout setting for queries in the worksheet's preferences. This gives long running
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Query Performance#Virtual Warehouses#SQL Optimization#Performance Tuning