
Explanation:
The correct answer is B because Snowflake's secure data sharing feature requires creating a share in the provider account and granting appropriate privileges to the consumer account. Option B correctly identifies the process of creating a share and assigning the proper role, which aligns with Snowflake's data sharing mechanism where the provider creates a share, grants object privileges to it, and the consumer uses IMPORT SHARE privilege to create a database from the share. Option A is incorrect because simply creating a share with the same name doesn't establish the proper sharing relationship. Option C is incorrect as data sharing in Snowflake works across different cloud providers and regions without requiring replication. Option D is invalid as PUT command is for loading data into stages, not for creating shares.
Ultimate access to all questions.
How can data be shared between two users in different Snowflake accounts?
A
Create a share with the same name as the original database.
B
Create a share and ensure the proper role is assigned to the share.
C
Ensure both users’ accounts are using the same cloud provider and region.
D
Use the PUT command to create a shared account.
No comments yet.