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

Question

A company is experiencing inconsistent query performance in their Snowflake environment. Some queries execute quickly, while others, seemingly similar, take significantly longer. They suspect that the virtual warehouse sizing is not optimal. Which of the following strategies would be the MOST comprehensive approach to diagnosing and resolving this issue, assuming you have access to Snowflake's monitoring tools and SQL?

Options

• AContinuously monitor the warehouse's CPU utilization and memory usage during peak hours. If
• BEnable the Query Acceleration Service. This will automatically improve query performance.
• CUse the Snowflake web interface to review query history and identify queries with long execution
• DImplement Resource Monitors to limit the credit usage of specific users or groups. This will prevent
• ECluster the tables that are frequently joined together, especially those involved in slow queries.

Explanation

While monitoring CPU utilization (A) is helpful, it's not the most comprehensive. Query Acceleration service (B) may help to accelerate, but will not diagnose the underlying issue. Resource Monitors (D) address credit usage but don't directly improve query performance. The most comprehensive approach is to analyze slow queries using query profiles (C) to understand bottlenecks. Then you must improve data locality by Clustering Tables(E). Also, the sizing of a warehouse needs monitoring over time to ensure its performing at it's best. The best choice is to first identify the root cause of performance issues (C, E) before taking action.

No community discussion yet for this question.