SOL-C01 Question #269: Real Exam Question with Answer & Explanation

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.

Explanation

Analyzing the Warehouse Load graph is the most effective method using Snowsight's monitoring features. This directly shows periods of high concurrency and queuing, indicating potential resource contention. Query History is useful, but analyzing the load graph is more targeted to warehouse performance as a starting point. Increasing warehouse size without understanding the bottleneck is premature. Downloading query execution plans is useful after identifying slow queries, and the Data Marketplace is irrelevant to performance monitoring.

No community discussion yet for this question.