Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 595

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

Which command should be used?

grant usage on share my_share to account xy12345;

grant select on share my_share to account xy12345;

alter share my_share add accounts = xy12345;

alter account xy12345 add share my_share;

Correct Answer: C

The correct command to share data using my_share with account xy12345 is 'alter share my_share add accounts = xy12345;'. This command modifies the share my_share by adding the specified consumer account xy12345, thereby enabling the sharing of data.

Discussion

MultiCloudIronManOption: C

ALTER SHARE [ IF EXISTS ] <name> { ADD | REMOVE } ACCOUNTS = <consumer_account> [ , <consumer_account> , ... ] [ SHARE_RESTRICTIONS = { TRUE | FALSE } ] ALTER SHARE [ IF ALTER SHARE [ IF EXISTS ] <name> SET { [ ACCOUNTS = <consumer_account> [ , <consumer_account> ... ] ]