Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam DEA-C01 Topic 1 Question 43 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 43
Topic #: 1
[All DEA-C01 Questions]

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? (Select TWO).

Show Suggested Answer Hide Answer
Suggested Answer: A, E

The ways that Company A can share data with Company B are:

Create a share within Company A's account and add Company B's account as a recipient of that share: This is a valid way to share data between different accounts on different cloud platforms and regions. Snowflake supports cross-cloud and cross-region data sharing, which allows users to create shares and grant access to other accounts regardless of their cloud platform or region. However, this option may incur additional costs for network transfer and storage replication.

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: This is also a valid way to share data between different accounts on different cloud platforms and regions. This option is similar to the previous one, except that it uses a separate database to isolate the data sets that need to be shared. This can improve security and manageability of the shared data. The other options are not valid because:

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: This option is not valid because reader accounts are not supported for cross-cloud or cross-region data sharing. Reader accounts are Snowflake accounts that can only consume data from shares created by their provider account. Reader accounts must be on the same cloud platform and region as their provider account.

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: This option is not valid because database replication cannot be used for cross-cloud or cross-region data sharing. Database replication is a feature in Snowflake that allows users to copy databases across accounts within the same cloud platform and region. Database replication cannot copy databases across different cloud platforms or regions.

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: This option is not valid because it involves creating a new account within Company A's organization, which may not be feasible or desirable for Company A. Moreover, this option is unnecessary, as Company A can directly share data with Company B without creating an intermediate account.


Contribute your Thoughts:

Caprice
7 days ago
I'm feeling a bit like a Snowflake juggler here. But I think B and D are the way to go. Create a reader account and then replicate the data to a new account. Gotta keep those clouds in sync, am I right?
upvoted 0 times
...
Luisa
9 days ago
Hah, this is like a game of Snowflake Tetris! I'd say A and E are the way to go. Keep it simple, you know?
upvoted 0 times
...
Latrice
17 days ago
I'm going with C and E. Replicating the data and then creating a share within Company B's account sounds like a solid plan. Plus, separating the data into a dedicated database is a smart move.
upvoted 0 times
...
Shawna
20 days ago
I'm torn between B and D. Database replication could be a good option, but setting up a new account in the same cloud provider and region as Company B might be more efficient.
upvoted 0 times
Vannessa
3 days ago
Yeah, that sounds like a good option. But setting up a new account in the same cloud provider and region as Company B could be more efficient.
upvoted 0 times
...
Cassie
8 days ago
I think creating a share within Company A's account and adding Company B's account as a recipient could work.
upvoted 0 times
...
...
Mike
28 days ago
Hmm, I think A and E are the way to go. Creating a share within Company A's account seems like the easiest option.
upvoted 0 times
Penney
9 days ago
Yes, and creating a separate database within Company A's account for sharing data with Company B is also a good idea.
upvoted 0 times
...
Teri
13 days ago
A) Create a share within Company A's account and add Company B's account as a recipient of that share
upvoted 0 times
...
Raylene
17 days ago
I agree, creating a share within Company A's account is a good option.
upvoted 0 times
...
...
Kimbery
1 months ago
I'm not sure about option C, as database replication might not be the most efficient way to share data between the two companies.
upvoted 0 times
...
Glenn
1 months ago
I agree with Ellsworth, but I also think option E could work well by creating a separate database for sharing specific data sets.
upvoted 0 times
...
Ellsworth
2 months ago
I think option A is a good choice because it allows Company A to directly share data with Company B.
upvoted 0 times
...

Save Cancel