Answer: A User-Defined Table Function (UDTF)

The question asks which Snowflake object can be referenced in the FROM clause and returns a set of rows with one or more columns. A User-Defined Table Function (UDTF) is specifically designed to return a table-like structure (set of rows with columns) and can be called directly in the FROM clause of a SQL query. The community discussion shows 100% consensus on option A, with upvoted comments referencing Snowflake documentation that confirms UDTFs can be called in the FROM clause. Other options are less suitable: Scalar UDFs return single values and are used in SELECT clauses, stored procedures execute procedural code but don't return tabular results directly in FROM clauses, and tasks are for scheduling jobs, not querying data.

Author: LeetQuiz Editorial Team