ExamGecko
Question list
Search
Search

Question 449 - COF-C02 discussion

Report
Export

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

A.
Clone the data from the production account to the non-production account.
Answers
A.
Clone the data from the production account to the non-production account.
B.
Create a data share from the production account to the non-production account.
Answers
B.
Create a data share from the production account to the non-production account.
C.
Create a subscription in the production account and have it publish to the non-production account.
Answers
C.
Create a subscription in the production account and have it publish to the non-production account.
D.
Create a reader account using the production account and link the reader account to the non-production account.
Answers
D.
Create a reader account using the production account and link the reader account to the non-production account.
Suggested answer: B

Explanation:

To easily transfer data from a production account to a non-production account in Snowflake within the same cloud provider region, creating a data share is the most efficient approach. Data sharing allows for live, read-only access to selected data objects from the production account to the non-production account without the need to duplicate or move the actual data. This method facilitates seamless access to the data for development, testing, or analytics purposes in the non-production environment.

References:

Snowflake Documentation: Data Sharing

asked 23/09/2024
Nika Longley
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first