Answer-first summary for fast verification
Answer: Create a data share from the production account to the non-production account.
The correct answer is B because data sharing is the most efficient and straightforward method to transfer data between Snowflake accounts in the same cloud region without physically moving or copying data. Option A (cloning) is incorrect as cloning cannot be performed across different Snowflake accounts. Option C (subscription) is not a valid Snowflake data transfer mechanism. Option D (reader account) is incorrect because reader accounts are designed for external consumers to access shared data, not for transferring data between internal accounts. The community discussion strongly supports B with 83% consensus and clear reasoning that cloning across accounts is not possible.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have two Snowflake accounts in the same cloud provider region: one for production and one for non-production. How can you easily transfer data from the production account to the non-production account?
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.
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.