Final answer:
In Snowflake, when a table is shared with another account, no actual data is copied or transferred; it is managed through the Snowflake metadata services layer, and the target account is not charged for data storage.
Step-by-step explanation:
When a table is shared by a Snowflake account to another Snowflake account, several things happen, but not all of the options in the question are correct. Specifically:
- No actual data is copied or transferred between accounts. Instead, the sharing mechanism relies on secure, managed access to the data without duplicating it.
- Sharing is managed through the Snowflake metadata services layer. Snowflake uses a feature called Secure Data Sharing to manage access permissions and visibility to the shared data, which requires no data copy or transfer.
- The target Snowflake account is not charged for the shared data storage, because the data continues to reside in the source account's storage.
Therefore, the correct answers are that no actual data is copied or transferred, and sharing is managed via the Snowflake metadata services layer.