SnowflakeSnowflake
COF-C02 · Question #250
COF-C02 Question #250: Real Exam Question with Answer & Explanation
The correct answer is B: TABLE. In Snowflake, a tabular User-Defined Function (UDF) is defined with a return clause that includes the keyword "TABLE." This indicates that the UDF will return a set of rows, which can be used in the FROM clause of a query.
Data Transformations
Question
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
Options
- AROW_NUMBER
- BTABLE
- CTABULAR
- DVALUES
Explanation
In Snowflake, a tabular User-Defined Function (UDF) is defined with a return clause that includes the keyword "TABLE." This indicates that the UDF will return a set of rows, which can be used in the FROM clause of a query.
Topics
#User-Defined Functions (UDFs)#Tabular UDFs (UDTFs)#SQL Syntax#CREATE FUNCTION
Community Discussion
No community discussion yet for this question.