ExamGecko
Question list
Search
Search

Question 449 - SnowPro Core 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.

Snowflake Documentation: Data Sharing

asked 29/10/2024
Arnold Bronson TCHOFFO
44 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first