SnowPro Core Certification — Question 881

Given the statement template below, which database objects can be added to a share? (Choose two.)

GRANT [privilege] ON [object] [object_name] TO SHARE [share_name];

Answer options

• A. Secure functions
• B. Stored procedures
• C. Streams
• D. Tables
• E. Tasks

Correct answer: A, D

Explanation

Secure functions and Tables are the only database objects that can be granted privileges to a share. Stored procedures, Streams, and Tasks cannot be shared in this manner, as they do not fit the criteria for being included in a share according to the provided GRANT statement template.