Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
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.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
jveag
Highly Voted 1 year, 7 months agoKarBiswa
1 year, 2 months agoVenkataPhaniPavanKumar
3 months, 1 week agomoon2351
Highly Voted 2 years, 4 months agosushant02
Most Recent 3 weeks agoAlex_Ovidiu
3 weeks, 6 days agoLena_Frazier
3 months agosandy91
3 months, 2 weeks agozephyrvz
6 months, 2 weeks agosaikot
8 months agoSamuelZhang
9 months, 3 weeks agoPoornaChandraIn
9 months, 3 weeks agoharshkoshta
10 months, 1 week agodevangmehta07
10 months, 2 weeks agotstander
10 months, 2 weeks agobonniezl
11 months, 1 week agoHarpreetwal
11 months, 3 weeks agoMayuri917233
11 months, 4 weeks agoRajuNaik
1 year ago