
Answer-first summary for fast verification
Answer: Create a reader account and create a share of the data
The correct answer is B because Snowflake's data sharing feature allows sharing data with external users who don't have Snowflake accounts through reader accounts. A reader account is specifically designed for this purpose - it's a limited, read-only account that can access shared data without requiring the consumer to have a full Snowflake account. Option A (UDFs) is incorrect as User-Defined Functions are for data processing, not data sharing. Option C (GRANT READER privilege) is insufficient as it only works within the same Snowflake account. Option D (moving account region) is irrelevant since data sharing capabilities are not region-dependent in this context. The community discussion shows 100% consensus on answer B with multiple upvoted comments confirming this is correct.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can a Snowflake user share data with a consumer who does not have a Snowflake account?
A
Share the data by implementing User-Defined Functions (UDFs)
B
Create a reader account and create a share of the data
C
Grant the READER privilege to the database that is going to be shared
D
Move the Snowflake account to a region where data sharing is enabled