Snowflake Architect Certification Data Sharing and Collaboration 2

Question 1

Which of the following data objects CANNOT be directly added to a Snowflake share?

Accepted Answer

Internal named stages

Answer

Standard tables

Answer

External tables

Answer

Secure views

Question 2

What immediately happens to a consumer's access when a provider removes a table from a Snowflake share?

Accepted Answer

The consumer loses access immediately since no data copy exists

Answer

The consumer retains a cached copy for 30 days

Answer

The consumer receives a deprecation warning for 7 days before access is revoked

Answer

The data is automatically archived to the consumer's storage tier

Question 3

In Snowflake, can a data consumer directly re-share data they received via a provider's share to another account?

Accepted Answer

No, consumers cannot directly re-share data from a provider's share

Answer

Yes, consumers can freely re-share any received data

Answer

Yes, but only within the same cloud provider and region

Answer

Yes, but only if the consumer holds a Business Critical Snowflake edition

Question 4

What is the primary purpose of Snowflake Data Clean Rooms?

Accepted Answer

A secure environment where multiple parties run joint analyses without exposing raw data to each other

Answer

A tool to automatically deduplicate and clean records in Snowflake tables

Answer

A compliance feature that anonymizes PII data before it is stored in Snowflake

Answer

A staging environment for validating data quality before production ingestion

Question 5

What is the key difference between a 'public listing' and a 'private listing' on the Snowflake Marketplace?

Accepted Answer

Public listings are discoverable by all Snowflake users; private listings are targeted at specific accounts

Answer

Public listings are always free; private listings always have a monetization fee

Answer

Public listings use standard shares; private listings require reader accounts

Answer

Public listings allow consumer re-sharing; private listings prohibit re-sharing

Question 6

Which Snowflake feature enables providers to share data with consumers located in a different cloud provider or region via the Marketplace?

Accepted Answer

Cross-Cloud Auto-Fulfillment

Answer

Multi-Cloud Data Exchange

Answer

Direct Share with region override

Answer

Global Database Replication

Question 7

What does granting USAGE ON DATABASE to a share object accomplish in Snowflake data sharing?

Accepted Answer

It enables consumers who import the share to see and query objects within that database

Answer

It allows the share to replicate the database to consumer regions automatically

Answer

It grants consumer accounts full administrative access to the database

Answer

It publishes the database as a public listing on the Snowflake Marketplace