SnowPro Advanced: Data Engineer — Question 31
Company A and Company B both have Snowflake accounts. Company A's account is hosted on a different cloud provider and region than Company B's account. Companies A and B are not in the same Snowflake organization.
How can Company A share data with Company B? (Choose two.)
Answer options
- A. Create a share within Company A's account and add Company B's account as a recipient of that share.
- B. Create a share within Company A's account, and create a reader account that is a recipient of the share. Grant Company B access to the reader account.
- C. Use database replication to replicate Company A's data into Company B's account. Create a share within Company B's account and grant users within Company B's account access to the share.
- D. Create a new account within Company A's organization in the same cloud provider and region as Company B's account. Use database replication to replicate Company A's data to the new account. Create a share within the new account, and add Company B's account as a recipient of that share.
- E. Create a separate database within Company A's account to contain only those data sets they wish to share with Company B. Create a share within Company A's account and add all the objects within this separate database to the share. Add Company B's account as a recipient of the share.
Correct answer: A, D
Explanation
Answer A is correct because it directly allows Company A to share data by adding Company B as a recipient to a share created in Company A's account. Answer D is also valid as it involves creating a new account that aligns with Company B's setup, enabling data sharing through replication and a share. The other options either do not facilitate sharing between the two distinct organizations effectively or require unnecessary steps that complicate the process.