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

Question

A data engineer is using Snowflake Notebooks to perform a series of transformations on a large dataset. After executing a cell containing a complex SQL query that includes user-defined functions (UDFs), the cell's execution status remains 'Running' for an unexpectedly long time. What are the MOST likely reasons for this prolonged execution time?

Options

• AThe UDFs within the query are inefficient and causing performance bottlenecks.
• BThe Snowflake warehouse is under-provisioned for the size and complexity of the query.
• CThe data being processed is heavily skewed, leading to uneven workload distribution across
• DThe Snowflake Notebook session has timed out due to inactivity.
• EThe cell is waiting for a lock on a table or object that is currently being modified by another

Explanation

Prolonged execution times can be attributed to several factors. Inefficient UDFs (A) directly impact performance. Under-provisioned warehouses (B) lack the resources to execute the query efficiently. Data skew (C) can cause some nodes to work harder than others. Lock contention (E) will cause the cell to wait. Session timeout (D) would result in an error, not a 'Running' status.

No community discussion yet for this question.