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

Question

A data scientist is using Snowflake Notebooks to analyze sales data. They have encountered a situation where a specific cell containing a complex UDF that calculates customer lifetime value is consistently failing with an obscure error. The error message is not providing enough information to pinpoint the root cause. Considering the limitations and features of Snowflake Notebooks, what is the MOST effective approach to debug this UDF without disrupting the entire notebook session and while preserving the data context within the notebook environment?

Options

• AReplace the UDF cell with a simple SELECT statement to confirm connectivity and basic notebook
• BDownload the entire notebook as a Python script, run it in a local Python environment with
• CLeverage the Snowflake query history to examine the compiled SQL generated by the UDF,
• DIsolate the UDF code and relevant input data into a separate Snowflake Stored Procedure. Debug
• ESince Snowflake Notebooks have limited debugging capabilities, the best approach is to rewrite

Explanation

Isolating the IJDF into a stored procedure allows for focused debugging using Snowflake's debugging tools. While options A and C are helpful for initial troubleshooting, they don't provide the same level of detailed debugging as option D. Option B is less efficient due to the need to translate code between environments, and option E might not be feasible if the UDF's complexity is necessary for accurate results.

No community discussion yet for this question.