SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ113

Secure Data Sharing and Consumption

A large manufacturing company operates a dozen separate Snowflake accounts across its business divisions. It wants to expand data sharing to support supply-chain optimization and strengthen its purchasing leverage with multiple vendors.

The company’s Snowflake Architects must design a solution that allows the business divisions to determine what they share while minimizing configuration and management effort. Most company divisions use Snowflake accounts in the same cloud deployments, with a few exceptions for European-based divisions.

According to Snowflake recommended best practice, how should these requirements be satisfied?

Explanation

A Private Data Exchange provides a governed, internal sharing hub in which divisions can publish the data products they choose and other authorized participants can discover them, avoiding the administrative overhead of managing numerous point-to-point relationships. Standard sharing serves accounts in the same deployment; cross-region sharing for European accounts requires Snowflake replication, including the relevant shared data and share objects, before the share can be consumed in the remote region.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!