Snowflake
SOL-C01 · Question #269
You are using the Snowsight user interface to monitor the performance of a Snowflake warehouse. You notice that the average query execution time is consistently high. Which of the following actions, p
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #269. The question stem and answer options stay visible for context.
Virtual Warehouses
Question
You are using the Snowsight user interface to monitor the performance of a Snowflake warehouse. You notice that the average query execution time is consistently high. Which of the following actions, performed DIRECTLY through Snowsight's monitoring features, would be MOST effective in identifying the root cause of the performance bottleneck?
Options
- AIncrease the warehouse size to the next larger size.
- BExamine the Query History page, filtering for queries executed by a specific user.
- CAnalyze the Warehouse Load graph to identify periods of high concurrency and queuing.
- DDownload the query execution plan for the slowest running query from the last 24 hours.
- ECheck the Data Marketplace to see if there are any new data sources available.
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
#Snowsight Monitoring#Warehouse Performance#Query Bottlenecks#Concurrency & Queuing