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…

Question

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

• A
  13% (5)
• B
  78% (31)
• C
  3% (1)
• E
  8% (3)

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.

No community discussion yet for this question.