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
What Snowflake feature allows data providers to share live, read-only data with consumers without copying or moving it?
Answer: Secure Data Sharing
Secure Data Sharing enables providers to share live data with consumers in real time without physically copying or transferring any data.
Which object is the primary container created by a provider to define what data objects are shared with consumer accounts?
Answer: Share
A SHARE object is created by the provider and contains references to databases, schemas, tables, or views to be shared with consumer accounts.
What is the role of a 'reader account' in Snowflake Secure Data Sharing?
Answer: A managed account created by a provider for non-Snowflake consumers
Reader accounts are managed Snowflake accounts created and owned by providers to give consumers who lack their own Snowflake account access to shared data.
When a consumer account queries shared data in Snowflake, which account is responsible for the compute costs incurred?
Answer: The consumer account
The consumer account pays for virtual warehouse compute costs when querying shared data, while the provider pays only for storage.
Which Snowflake object type allows data sharing with built-in row-level security without exposing the underlying SQL logic to consumers?
Answer: Secure View
Secure Views hide the view definition from consumers and can implement row-level security filters, making them ideal for controlled data sharing.
What is the Snowflake Marketplace primarily used for?
Answer: A platform where providers publish data products for consumers to discover and access
Snowflake Marketplace is a platform where data providers publish and optionally monetize data products that consumers can discover, request, and use.
Which privilege must be granted to a share at the database level before consumer accounts can import and access the shared objects?
Answer: USAGE on the database
The USAGE privilege on the database and schema must be granted to the share object so consumer accounts can import and navigate the shared database.