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
Which of the following data objects CANNOT be directly added to a Snowflake share?
Answer: Internal named stages
Internal named stages cannot be included in a share; shareable objects are limited to tables, external tables, secure views, secure materialized views, and secure UDFs.
What immediately happens to a consumer's access when a provider removes a table from a Snowflake share?
Answer: The consumer loses access immediately since no data copy exists
Because Snowflake data sharing is zero-copy with live access, removing an object from a share immediately revokes the consumer's ability to query it.
In Snowflake, can a data consumer directly re-share data they received via a provider's share to another account?
Answer: No, consumers cannot directly re-share data from a provider's share
Snowflake does not allow consumers to directly re-share data from a received share; they would need to copy data into their own tables before creating a new share.
What is the primary purpose of Snowflake Data Clean Rooms?
Answer: A secure environment where multiple parties run joint analyses without exposing raw data to each other
Snowflake Data Clean Rooms allow organizations to collaborate on combined datasets and run joint queries without either party ever seeing the other's raw underlying data.
What is the key difference between a 'public listing' and a 'private listing' on the Snowflake Marketplace?
Answer: Public listings are discoverable by all Snowflake users; private listings are targeted at specific accounts
Public listings are visible and discoverable by any Snowflake user globally, while private listings are only offered to specific designated consumer accounts.
Which Snowflake feature enables providers to share data with consumers located in a different cloud provider or region via the Marketplace?
Answer: Cross-Cloud Auto-Fulfillment
Cross-Cloud Auto-Fulfillment automatically replicates shared Marketplace data to match the consumer's cloud provider and region, enabling seamless cross-cloud data sharing.
What does granting USAGE ON DATABASE to a share object accomplish in Snowflake data sharing?
Answer: It enables consumers who import the share to see and query objects within that database
Granting USAGE on a database to a share makes the database visible and accessible to consumer accounts that import the share.