Question 170
A SQL query requires a reusable scalar calculation while a maintenance workflow must execute several SQL statements. The team proposes this action: Use a UDF for the scalar expression and a stored procedure for the multi-step workflow. Why should that action address the stated requirement?
Explanation
Correct Answer
A UDF returns a value in a supported expression context, while a stored procedure orchestrates procedural operations. This explains the proposed action: use a UDF for the scalar expression and a stored procedure for the multi-step workflow.
Incorrect Answers
Snowsight provides an interactive web experience for SQL workflows and administration views. That rationale explains use Snowsight to explore objects, run worksheets, and examine query history in the browser. It does not establish the mechanism needed here: A UDF returns a value in a supported expression context, while a stored procedure orchestrates procedural operations.
An editor integration keeps source files in the development workflow while executing SQL against the chosen Snowflake account. That rationale explains use a supported IDE integration with authenticated Snowflake connectivity and checked-in SQL files. It does not establish the mechanism needed here: A UDF returns a value in a supported expression context, while a stored procedure orchestrates procedural operations.
Cortex Search is built for retrieval over enterprise text that can support grounded application experiences. That rationale explains use Cortex Search for managed search over the authorized text corpus. It does not establish the mechanism needed here: A UDF returns a value in a supported expression context, while a stored procedure orchestrates procedural operations.





SnowPro Core COF-C03 Practice Tests