SnowPro Advanced: Data Engineer — Question 61

A secure function returns data coming through an inbound share.
What will happen if a Data Engineer tries to assign USAGE privileges on this function to an outbound share?

Answer options

• A. An error will be returned because the Engineer cannot share data that has already been shared.
• B. An error will be returned because only views and secure stored procedures can be shared.
• C. An error will be returned because only secure functions can be shared with inbound shares.
• D. The Engineer will be able to share the secure function with other accounts.

Correct answer: A

Explanation

The correct answer is A because secure functions that return data through inbound shares cannot be shared again through outbound shares. Options B and C are incorrect because they refer to the properties of other objects and shares, not the specific situation at hand. Option D is also incorrect as it contradicts the limitations of sharing secure functions.