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

Question

A user executes the following SQL statement in Snowflake: SELECT FROM MY TABLE; The user reports that the query is running very slowly. Assuming the user has the necessary permissions to access the table, which of the following could be the cause of the slow query performance and how could you verify that the root cause is the bottleneck?

Options

• AThe virtual warehouse is undersized. Check the query profile in Snowsight to observe spill to local
• BThe table 'MY _ TABLE is not clustered properly. Run 'SYSTEM$CLUSTERING_INFORMATION'
• CThe _ TABLE table is very wide with numerous columns, making it inefficient to select all columns.
• DNetwork latency between the user's location and the Snowflake region is high. Run a network
• EThe query is waiting on lock contention. Check the LOCK WAIT TIME column in the QUERY

Explanation

A virtual warehouse that is undersized will lead to queries that spill to local or remote disks. Table being not clustered properly. Table being too wide and inefficient. Option D is highly unlikely as you can see how the query processes internally in query profile and it can be ruled out quickly. Check the query profile in Snowsight to observe spill to local disk or remote storage. Run function to check the clustering depth and verify how much the table is clustered. The query profile also shows that the 'SELECT operation is taking a significant amount of time.

No community discussion yet for this question.