SnowPro Core free question 9 / 10 · Domain 5: Data Collaboration
How is data handled when it is shared with Secure Data Sharing?
- The data is handed over to the consumer through a stage
- The data is replicated into a copy owned by the consumer
- The data is transferred to the consumer in a nightly batch
- No actual data is copied or transferred between accounts
Show the answer and explanation
Answer: D
Why this is correct
With Secure Data Sharing, no actual data is copied or transferred between accounts. All sharing uses Snowflake's services layer and metadata store. Because no data is copied or exchanged, setup is quick for the provider and access is near-instant for the consumer.
Why the other options are wrong
"The data is replicated into a copy owned by the consumer" … Nothing is replicated into a consumer-owned copy.
"The data is transferred to the consumer in a nightly batch" … There is no nightly transfer. The consumer reads the provider's data in place.
"The data is handed over to the consumer through a stage" … Sharing works through metadata, not by passing files through a stage.
Key point
Shared data does not take up any storage in the consumer account. The only charges to consumers are for the compute resources, that is, the virtual warehouses, used to query the imported data.
Go to the SnowPro Core practice app (10 free questions; purchase unlocks all questions)