SnowPro Core Certification — Question 388

Which Snowflake object can be accessed in the FROM clause of a query, returning a set of rows having one or more columns?

Answer options

• A. A User-Defined Table Function (UDTF)
• B. A Scalar User Defined Function (UDF)
• C. A stored procedure
• D. A task

Correct answer: A

Explanation

The correct answer is A, as a User-Defined Table Function (UDTF) is specifically designed to return a set of rows that can be used in the FROM clause. Options B and C do not return sets of rows: a Scalar UDF returns a single value, and a stored procedure is used for executing business logic rather than producing a table-like output. Option D, a task, is for scheduling SQL statements and does not return rows.