SOL-C01 · Question #302
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
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #302. The question stem and answer options stay visible for context.
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
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.