exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 696 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 696
Topic #: 1
[All SnowPro Core Questions]

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

  • A. There are multiple SQL UDFs with the same names and the same number of arguments.
  • B. There are multiple SQL UDFs with the same names and the same number of argument types.
  • C. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.
  • D. There are multiple SQL UDFs with different names but the same number of arguments or argument types.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
nexerSnow
8 months, 4 weeks ago
Selected Answer: C
Overloading procedures and functions Snowflake supports overloading procedures and functions. In a given schema, you can define multiple procedures or functions that have the same name but different signatures. The signatures must differ by the number of arguments, the types of the arguments, or both. https://docs.snowflake.com/en/developer-guide/udf-stored-procedure-naming-conventions#overloading-procedures-and-functions
upvoted 1 times
...
tennyalad
1 year ago
Selected Answer: C
https://docs.snowflake.com/en/developer-guide/udf-stored-procedure-naming-conventions#overloading-procedures-and-functions
upvoted 1 times
...
MultiCloudIronMan
1 year, 3 months ago
Selected Answer: C
https://www.bing.com/search?q=When+referring+to+User-Defined+Function+%28UDF%29+names+in+Snowflake%2C+what+does+the+term+overloading+mean%3F&qs=n&form=QBRE&sp=-1&lq=1&pq=when+referring+to+user-defined+function+%28udf%29+names+in+snowflake%2C+what+does+the+term+overloading+mean%3F&sc=1-102&sk=&cvid=9657B73889BB4C33A673D15B5035044C&ghsh=0&ghacc=0&ghpl=
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago