Exam SnowPro Core topic 1 question 75 discussion

ALL is correct. https://docs.snowflake.com/en/sql-reference/user-defined-functions.html Snowflake currently supports the following languages for writing UDFs: Java: A Java UDF lets you use the Java programming language to manipulate data and return either scalar or tabular results. JavaScript: A JavaScript UDF lets you use the JavaScript programming language to manipulate data and return either scalar or tabular results. Python: A Python UDF lets you use the Python programming language to manipulate data and return either scalar or tabular results. SQL: A SQL UDF evaluates an arbitrary SQL expression and returns either scalar or tabular results.

User-defined functions (UDFs) let you extend the system to perform operations that are not available through the built-in, system-defined functions provided by Snowflake. Snowflake currently supports the following languages for writing UDFs: SQL: A SQL UDF evaluates an arbitrary SQL expression and returns either scalar or tabular results. JavaScript: A JavaScript UDF lets you use the JavaScript programming language to manipulate data and return either scalar or tabular results. Java: A Java UDF lets you use the Java programming language to manipulate data and return either scalar or tabular results.

Only B, C is correct! https://docs.snowflake.com/en/developer-guide/udf/udf-overview --> Actually, Snowflake officially supports UDF implementations in four languages: (Java, JavaScript, SQL, Python) BUT, You must clearly understand the context in which this question is asked. Typically, Snowflake's certification exams and courses require JavaScript and SQL as default answers for the following reasons: ① Default Support : JavaScript and SQL UDFs are supported natively in all Snowflake editions without any additional setup or package installation. ② Java and Python UDFs have separate requirements : To use Java and Python UDFs, you need to activate the Snowpark feature provided by Snowflake, install related packages, and configure a separate environment. (https://docs.snowflake.com/en/developer-guide/udf/udf-overview)

All correct ABCD

Ans is all. But only SQL and JavaScript UDFs are sharable.

Only Javascript and SQL

For the SnowPro Core exam, the two correct languages that can be used to implement Snowflake User Defined Functions (UDFs) are: B. Javascript C. SQL Here's the explanation: Supported languages for UDFs: 1. SQL: - Most common type of UDF - Written in SQL/ANSI syntax - Used for scalar and table functions - Runs natively in Snowflake 2. Javascript: - Supports more complex logic - Runs in secure sandbox environment - Can handle advanced calculations - Allows for more programming flexibility The incorrect options: - A. Java: Not supported for UDFs in Snowflake - D. Python: Not supported for UDFs (Note: Python is supported for Stored Procedures, but not for UDFs) Key points for the exam: - Only SQL and Javascript are supported for UDFs - Don't confuse UDF language support with Stored Procedure language support - JavaScript UDFs run in a secure execution environment - SQL UDFs are most commonly used

Issue here is that I cannot select all the options even though all answers are correct

All are correct. However, you can only share SQL and JavaScript UDFs

All are correct https://docs.snowflake.com/en/developer-guide/udf/udf-overview#label-udf-supported-languages

UDFs Can be written in o SQL o Python o Scala o Java o JavaScript

All options are correct

All correct, capisce?

correct answer:ABCD

All answers are correct. Also Java and Javascript are supported. https://docs.snowflake.com/en/developer-guide/udf/udf-overview#label-udf-supported-languages

All four are correct.

Here are the languages you can use to implement Snowflake User Defined Functions (UDFs) (choose two): A. Java (Most Voted) C. SQL (Most Voted) Snowflake supports the following languages for creating UDFs: SQL: You can write UDFs directly in standard SQL, allowing you to perform calculations or transformations within your queries. Java: Snowflake provides a Java API for developing UDFs. This option is useful for complex logic or functionalities that might be challenging to implement purely in SQL. Here's why the other options are not supported for UDF creation in Snowflake: B. Javascript: While JavaScript is a popular language, Snowflake doesn't currently support JavaScript for UDF development. D. Python: Similar to Javascript, Python is not a supported language for UDFs in Snowflake at this time.