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…

Question

Options

• AClone the data from the production account to the non-production account.
• BCreate a data share from the production account to the non-production account.
• CCreate a subscription in the production account and have it publish to the non-production account.
• DCreate a reader account using the production account and link the reader account to the non-

• A
  2% (1)
• B
  90% (43)
• C
  4% (2)
• D
  4% (2)

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.

No community discussion yet for this question.