ADA-C01 · Question #27
A large international company with many operating regions requires data to be shared bi- directionally among all offices (head office to regional offices and regional offices among themselves). This…
The correct answer is D. Use bi-directional data sharing among offices in the same region and replication among offices. Data sharing is a feature that allows sharing selected objects in a database in one account with other accounts in the same organization, without copying or transferring any data. Data sharing is supported across regions and across cloud platforms, but it requires enabling…
Question
A large international company with many operating regions requires data to be shared bi- directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe. How can this data be shared bi-directionally, while MINIMIZING costs?
Options
- AUse data replication everywhere to reduce costs associated with same-region sharing.
- BUse the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an
- CMove all the Snowflake accounts to a single region, and implement data sharing.
- DUse bi-directional data sharing among offices in the same region and replication among offices
How the community answered
(23 responses)- A4% (1)
- B9% (2)
- C13% (3)
- D74% (17)
Explanation
Data sharing is a feature that allows sharing selected objects in a database in one account with other accounts in the same organization, without copying or transferring any data. Data sharing is supported across regions and across cloud platforms, but it requires enabling account database replication for both the source and target accounts. Data replication is a feature that allows replicating objects from a source account to one or more target accounts in the same organization, providing read-only access for the replicated objects. Data replication is also supported across regions and across cloud platforms, but it incurs additional storage costs for the replicated data. Therefore, the best way to share data bi-directionally among all offices, while minimizing costs, is to use data sharing among offices in the same region, which does not require replication or additional storage, and use replication among offices across the continents, which provides near real-time access to the shared data.
Topics
Community Discussion
No community discussion yet for this question.