Which of the following is NOT true about external functions?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

Which of the following is NOT true about external functions?

Explanation:
External functions in Snowflake let you call external services from SQL. You can have multiple external functions with the same name but different input signatures, so you can overload them. That’s why the statement that they cannot be overloaded isn’t true. They can accept parameters just like other functions, and Snowflake passes those values to the external handler. The return value can be a compound value, such as a VARIANT containing JSON, which Snowflake can represent as VARIANT/OBJECT/ARRAY.

External functions in Snowflake let you call external services from SQL. You can have multiple external functions with the same name but different input signatures, so you can overload them. That’s why the statement that they cannot be overloaded isn’t true. They can accept parameters just like other functions, and Snowflake passes those values to the external handler. The return value can be a compound value, such as a VARIANT containing JSON, which Snowflake can represent as VARIANT/OBJECT/ARRAY.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy