SOL-C01 · Question #210
SOL-C01 Question #210: Real Exam Question with Answer & Explanation
The correct answer is C: The 'SNOWFLAKE.ML.COMPLETE function is disabled at the account level. Requires enabling it. The error `Unsupported feature 'External functions" strongly indicates that external functions are disabled at the account level. While other options might contribute to issues in other scenarios, this error message directly points to the need to enable external functions using t
Question
You are using the 'SNOWFLAKE.ML.COMPLETE function in Snowflake Cortex to generate creative text formats, specifically poems, based on customer feedback. You have a table 'FEEDBACK' with a 'TEXT column. However, you are consistently encountering the following error: 'SQL compilation error: Unsupported feature 'External functions". What is the MOST likely cause of this error?
Options
- AThe 'SNOWFLAKE.ML.COMPLETE function is only available in specific regions, and your
- BThe 'SNOWFLAKE.ML.COMPLETE function requires a minimum Snowflake edition (e.g.,
- CThe 'SNOWFLAKE.ML.COMPLETE function is disabled at the account level. Requires enabling it
- DThe virtual warehouse being used does not have sufficient resources allocated to it.
- EThe user executing the query lacks the necessary privileges to call external functions.
Explanation
The error `Unsupported feature 'External functions" strongly indicates that external functions are disabled at the account level. While other options might contribute to issues in other scenarios, this error message directly points to the need to enable external functions using the provided ALTER ACCOUNT statement. Snowflake Cortex ML Complete function is implemented as extemal function internally.
Topics
Community Discussion
No community discussion yet for this question.