
Answer-first summary for fast verification
Answer: Secure functions, Tables
According to Snowflake documentation and the community discussion consensus (89% agreement with AD), the objects that can be added to a share using the GRANT statement include secure functions (option A) and tables (option D). Secure functions are explicitly listed as shareable objects in Snowflake's data sharing capabilities, while tables are the fundamental shareable object. Stored procedures (B) cannot be directly shared, streams (C) are for change data capture and not shareable, and tasks (E) are workflow objects that cannot be shared. The community discussion references official Snowflake documentation confirming that secure views, secure materialized views, and secure UDFs (functions) along with tables can be shared.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.