Answer-first summary for fast verification
Answer: Create a share and ensure the proper role is assigned to the share.
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.
Author: LeetQuiz Editorial Team
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.