SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 75


Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? (Choose two.)

Show Answer
Correct Answer:

Snowflake User Defined Functions (UDFs) can be implemented using Javascript and Python. Javascript allows for performing various calculations and operations within Snowflake using the flexibility of the language. Python UDFs leverage the Python programming language to extend the capabilities of Snowflake through powerful scripting and data manipulation.

Discussion

17 comments
Sign in to comment
jveagOptions: AB
Sep 9, 2022

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.

KarBiswa
Feb 8, 2023

https://docs.snowflake.com/en/sql-reference/udf-overview.html all are correct

VenkataPhaniPavanKumar
Jan 27, 2024

All options are correct according to snowflake doc https://docs.snowflake.com/en/developer-guide/udf/udf-overview#supported-languages

moon2351Options: AB
Jan 3, 2022

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.

tstanderOptions: BC
Jun 21, 2023

Can write in all of them, however only Javascript and SQL ones are shareable. https://docs.snowflake.com/sql-reference/udf-overview#label-udf-supported-languages:~:text=Data%20Sharing%20feature.-,Language,Sharable,-Java

pranalig
Jun 16, 2024

correct answer:ABCD

devangmehta07
Jun 22, 2023

A B C D

harshkoshta
Jun 28, 2023

ABCD, snowlfkae now support all

PoornaChandraIn
Jul 11, 2023

All answers are correct. https://docs.snowflake.com/en/sql-reference/udf-overview

SamuelZhangOptions: AB
Jul 12, 2023

ALL is correct. https://docs.snowflake.com/en/sql-reference/user-defined-functions.html

saikot
Aug 30, 2023

ABCD all are correct answer

zephyrvzOptions: AB
Oct 22, 2023

all is correct

sandy91
Jan 15, 2024

ALL ARE TRUE

Lena_Frazier
Jan 30, 2024

It's all of the above: https://docs.snowflake.com/developer-guide/udf/udf-overview#label-udf-supported-languages

Alex_OvidiuOptions: AC
Apr 5, 2024

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.

Sushant_02
Apr 11, 2024

All four are correct.

Stevec80Options: CD
May 12, 2024

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

levisn1
Jun 18, 2024

All correct, capisce?

Mallikharjuna452
Jul 18, 2024

All options are correct