Snowflake
SOL-C01 · Question #245
Consider a scenario where you need to create a custom function (UDF) in Snowflake that uses an external Python library not available in the Snowflake Anaconda channel. How would you package and deploy
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #245. The question stem and answer options stay visible for context.
Querying and Performance
Question
Consider a scenario where you need to create a custom function (UDF) in Snowflake that uses an external Python library not available in the Snowflake Anaconda channel. How would you package and deploy this UDF, ensuring proper dependency management and version control?
Options
- ACreate a Python virtual environment, install the necessary libraries, and upload the entire
- BInstall the required Python libraries directly on the Snowflake compute nodes using a startup script,
- CPackage the UDF code and the external library as a single Python file, upload it to a Snowflake
- DUse the `snowflake-snowpark-python' library to create a Snowpark session, package the UDF and
- ECopy the source code of the external Python library and include it directly within the UDF
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.
Topics
#Python UDFs#External Dependencies#Snowpark#Dependency Management