Data Sharing and Collaboration Flashcards
7 cards from real Snowflake Architect Certification practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Sharing and Collaboration flashcards as text
In Snowflake's data sharing model, how are storage costs allocated between the provider and consumer?
Answer: Only the provider pays for storage; consumers pay only for compute when querying
Shared data physically resides in the provider's storage, so the provider pays storage costs while the consumer only pays for virtual warehouse compute used to query it.
Which DDL command does a Snowflake architect use to list all outbound shares created in and inbound shares available to the current account?
Answer: SHOW SHARES
SHOW SHARES displays all outbound shares created by the current account and all inbound shares from providers that are available for import.
A Snowflake architect wants to share data with an external organization that has no Snowflake account. What is the recommended approach?
Answer: Create a reader account for the external organization
Reader accounts are managed Snowflake accounts provisioned by the provider specifically for organizations that don't have their own Snowflake account.
Starting from which Snowflake edition can an account act as a data sharing provider using Secure Data Sharing?
Answer: Standard Edition
Secure Data Sharing provider capabilities are available beginning with the Standard Edition, making the feature accessible to all Snowflake customers.
What is the primary security advantage of sharing a Secure View rather than sharing the underlying base table directly?
Answer: Secure Views allow providers to filter rows and columns, limiting exactly what data consumers can access
Secure Views let providers implement row-level and column-level access control so consumers only see the specific data subset the provider intends to expose.
In Snowflake's data sharing architecture, what does the term 'zero-copy' specifically mean?
Answer: No data is physically duplicated — consumers access provider data live via shared metadata pointers
Zero-copy sharing means Snowflake shares metadata pointers to the provider's existing micro-partitions rather than duplicating the data, enabling live access with no physical data transfer.
Which schema in the SNOWFLAKE system database provides providers with visibility into how consumers are querying their shared data?
Answer: SNOWFLAKE.DATA_SHARING_USAGE
The SNOWFLAKE.DATA_SHARING_USAGE schema contains views that expose metrics on consumer query activity, listing requests, and usage patterns against the provider's shares.