How do Snowflake data providers share data that resides in different databases?

The correct answer is B. Secure views. In Snowflake's data sharing model, a share object can only directly reference tables and other objects within a single database. To share data that spans multiple databases, providers create secure views in one database that query tables from other databases using fully…

Data Protection and Data Sharing

Question

Options

AExternal tables
BSecure views
CMaterialized views
DUser-Defined Functions (UDFs)

How the community answered

(52 responses)

A
2% (1)
B
90% (47)
C
2% (1)
D
6% (3)

Explanation

In Snowflake's data sharing model, a share object can only directly reference tables and other objects within a single database. To share data that spans multiple databases, providers create secure views in one database that query tables from other databases using fully qualified object names (database.schema.table). Because secure views hide their underlying query definition from the consumer, they protect the provider's data model while still making cross-database data accessible through a share. The secure view itself lives in the shared database, acting as the unified access point. External tables (A) expose external data sources but are not the mechanism for cross-database sharing. Materialized views (C) and UDFs (D) can be included in shares but are not the primary mechanism for unifying data across multiple databases.

Topics

#Data Sharing#Secure Views#Cross-Database Sharing

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice