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

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?

Accepted Answer

The consumer loses access immediately since no data copy exists

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

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

Answer

Public listings are visible and discoverable by any Snowflake user globally, while private listings are only offered to specific designated consumer accounts.

Snowflake Architect Certification Practice Test

Snowflake Architect Certification Practice Test

Snowflake Architect Certification Data Sharing and Collaboration 2