SnowPro Core Certification — Question 973

What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

Answer options

• A. Use the automatic sharing feature for seamless access.
• B. Drop the object and then re-add it to the database to trigger sharing.
• C. Recreate the object with a different name in the database before sharing.
• D. Use the GRANT privilege ... TO SHARE command to grant the necessary privileges.

Correct answer: D

Explanation

The correct answer is D because the GRANT privilege ... TO SHARE command explicitly allows the user to grant the necessary permissions for sharing the object. Options A, B, and C are incorrect as they do not provide a method to properly grant access to the object for sharing with consumers.