SOL-C01 · Question #261
SOL-C01 Question #261: Real Exam Question with Answer & Explanation
The correct answer is B: Change the worksheet's preferred warehouse to a larger size (e.g., from X-Small to Large) with. Increasing the warehouse size (Option B) provides more compute resources, which can significantly improve the performance of complex queries. Splitting the query into smaller parts (Option D) can reduce the load on the worksheet and prevent it from freezing. Option A could potent
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
Explanation
Increasing the warehouse size (Option B) provides more compute resources, which can significantly improve the performance of complex queries. Splitting the query into smaller parts (Option D) can reduce the load on the worksheet and prevent it from freezing. Option A could potentially worsen the situation by adding more queries to overwhelm the worksheet. Option C will only help subsequent identical queries. Option E extends time to get results, not performance.
Topics
Community Discussion
No community discussion yet for this question.