SnowPro Core Certification — Question 625

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

Answer options

• A. ROW_NUMBER
• B. TABLE
• C. TABULAR
• D. VALUES

Correct answer: B

Explanation

The correct answer is B, TABLE, as it is the keyword used in the return clause of a tabular UDF to specify that the function returns a table structure. The other options, while related to SQL functions or queries, do not pertain to defining the return type of a UDF.