SnowPro Core Certification — Question 487

A Snowflake user wants to share data using my_share with account xy12345.

Which command should be used?

Answer options

• A. grant usage on share my_share to account xy12345;
• B. grant select on share my_share to account xy12345;
• C. alter share my_share add accounts = xy12345;
• D. alter account xy12345 add share my_share;

Correct answer: C

Explanation

The correct answer is C, as the command 'alter share my_share add accounts = xy12345;' specifically adds the account xy12345 to the share my_share. Options A and B are incorrect because they deal with granting permissions rather than adding an account to the share. Option D is also incorrect since it attempts to add the share to the account instead of adding the account to the share.