Snowflake Architect Certification Data Sharing and Collaboration 2 — Questions and Answers
Question 1: Which of the following data objects CANNOT be directly added to a Snowflake share?
- Standard tables
- External tables
- Secure views
- Internal named stages (Correct answer)
Correct 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.
Question 2: What immediately happens to a consumer's access when a provider removes a table from a Snowflake share?
- The consumer retains a cached copy for 30 days
- The consumer loses access immediately since no data copy exists (Correct answer)
- The consumer receives a deprecation warning for 7 days before access is revoked
- The data is automatically archived to the consumer's storage tier
Correct 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.
Question 3: In Snowflake, can a data consumer directly re-share data they received via a provider's share to another account?
- Yes, consumers can freely re-share any received data
- No, consumers cannot directly re-share data from a provider's share (Correct answer)
- Yes, but only within the same cloud provider and region
- Yes, but only if the consumer holds a Business Critical Snowflake edition
Correct 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.
Question 4: What is the primary purpose of Snowflake Data Clean Rooms?
- A tool to automatically deduplicate and clean records in Snowflake tables
- A secure environment where multiple parties run joint analyses without exposing raw data to each other (Correct answer)
- A compliance feature that anonymizes PII data before it is stored in Snowflake
- A staging environment for validating data quality before production ingestion
Correct 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.
Question 5: What is the key difference between a 'public listing' and a 'private listing' on the Snowflake Marketplace?
- Public listings are always free; private listings always have a monetization fee
- Public listings are discoverable by all Snowflake users; private listings are targeted at specific accounts (Correct answer)
- Public listings use standard shares; private listings require reader accounts
- Public listings allow consumer re-sharing; private listings prohibit re-sharing
Correct 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.
Question 6: Which Snowflake feature enables providers to share data with consumers located in a different cloud provider or region via the Marketplace?
- Multi-Cloud Data Exchange
- Direct Share with region override
- Cross-Cloud Auto-Fulfillment (Correct answer)
- Global Database Replication
Correct 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.
Question 7: What does granting USAGE ON DATABASE to a share object accomplish in Snowflake data sharing?
- It allows the share to replicate the database to consumer regions automatically
- It enables consumers who import the share to see and query objects within that database (Correct answer)
- It grants consumer accounts full administrative access to the database
- It publishes the database as a public listing on the Snowflake Marketplace
Correct 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.
