SnowPro Core Certification — Question 687

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

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because overloading allows the same UDF name to be used for different implementations based on argument count or type, enabling more flexible function use. Options A and B are incorrect as they imply identical argument counts or types, which does not constitute overloading. Option D incorrectly states that different names can be used, which is not the essence of overloading.