nerdexam
Snowflake

COF-R02 · Question #162

Which of the following describes external functions in Snowflake?

The correct answer is A. They are a type of User-defined Function (UDF). External functions are user-defined functions that are stored and executed outside of Snowflake. External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature…

Querying and Performance

Question

Which of the following describes external functions in Snowflake?

Options

  • AThey are a type of User-defined Function (UDF).
  • BThey contain their own SQL code.
  • CThey call code that is stored inside of Snowflake.
  • DThey can return multiple rows for each row received

How the community answered

(37 responses)
  • A
    81% (30)
  • B
    5% (2)
  • C
    3% (1)
  • D
    11% (4)

Explanation

External functions are user-defined functions that are stored and executed outside of Snowflake. External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your

Topics

#external functions#UDF#user-defined functions#API integration

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice