Discover the two languages, Scala and SQL, that require User-Defined Function (UDF) handlers to be written inline in Snowflake. Learn why this is necessary and how it differs from other languages like Java, JavaScript, and Python.
Table of Contents
Question
Which languages require that User-Defined Function (UDF) handlers be written inline? (Choose two.)
A. Java
B. Javascript
C. Scala
D. Python
E. SQL
Answer
C. Scala
E. SQL
Explanation
Scala and SQL require UDF handlers to be written inline within the query or script. This means that the function logic must be defined directly in the SQL or Scala code, rather than being referenced from an external source or library.
In contrast, languages like Java, JavaScript, and Python allow UDF handlers to be defined as separate functions or methods in external code files or libraries, which can then be referenced and called from within SQL queries or Scala scripts.
Snowflake SnowPro Core certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Core exam and earn Snowflake SnowPro Core certification.