
Answer-first summary for fast verification
Answer: Provide each non-Snowflake supplier with their own reader account., Use a data share for suppliers in the same cloud region and a replicated proxy share for other cloud deployments.
The question requires selecting two best practices for sharing transactional data with retail suppliers, some of whom don't use Snowflake. Option A (providing each non-Snowflake supplier with their own reader account) is correct because reader accounts allow secure data sharing with non-Snowflake users while maintaining isolation and control. Option D (using data shares for same-region suppliers and replicated proxy shares for other cloud deployments) is correct because it efficiently handles cross-region data sharing for Snowflake users while ensuring data locality and performance. Option B is incorrect because sharing a single reader account among all suppliers violates security best practices. Option C is inefficient as ETL pipelines are complex and not the recommended approach for direct data sharing. Option E is suboptimal as external stages and cloud utilities add unnecessary complexity compared to native Snowflake sharing features. The community discussion strongly supports A and D with 91% consensus and multiple upvoted comments referencing Snowflake documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A Snowflake user needs to share transactional data with retail suppliers, some of whom do not use Snowflake. According to best practice, which two actions should the user take?
A
Provide each non-Snowflake supplier with their own reader account.
B
Deploy a single reader account to be shared by all of the non-Snowflake suppliers.
C
Create an ETL pipeline that uses select and inserts statements from the source to the target supplier accounts.
D
Use a data share for suppliers in the same cloud region and a replicated proxy share for other cloud deployments.
E
Extract the shared transactional data to an external stage and use cloud storage utilities to reload the suppliers' regions.
No comments yet.