SnowPro Core Certification — Question 415
A Snowflake user wants to share transactional data with retail suppliers. However, some of the suppliers do not use Snowflake.
According to best practice, what should the Snowflake user do? (Choose two.)
Answer options
- 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.
Correct answer: A, D
Explanation
Providing each non-Snowflake supplier with their own reader account (Option A) is a recommended practice as it allows for secure, individualized access to the data. Using a data share for suppliers in the same cloud region and a replicated proxy share for others (Option D) ensures that data is efficiently and effectively shared across different cloud deployments. The other options either complicate the setup or do not adhere to best practices for data sharing.