Snowpro Core · Free Practice Question Medium
Question 82
Which of the following requirements can be fulfilled by only a secure UDF? Select all that apply.
- A There is a requirement to protect data by limiting some table columns from the result set.
- B There is a requirement to protect data by limiting a subset of rows from the result set.
- C There is a requirement to simplify complex SQL so that users don't have to re-code the same logic repeatedly.
Reveal correct answers
Correct answers: A, B
Explanation
SQL UDFs should be created as secure if their purpose is to protect data, such as views that limit the rows returned to the user or the columns. https://docs.snowflake.com/en/developer-guide/secure-udf-procedureDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
