Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

The correct answer is B. External tables C. Secure User-Defined Functions (UDFs). Snowflake Secure Data Sharing supports sharing external tables (B) and secure UDFs (C), along with tables, secure views, and secure materialized views. External tables allow providers to share structured references to data stored in external cloud storage. Secure UDFs can be…

Data Protection and Data Sharing

Question

Options

AFiles
BExternal tables
CSecure User-Defined Functions (UDFs)
DSequences
EStreams

How the community answered

(50 responses)

B
94% (47)
D
2% (1)
E
4% (2)

Explanation

Snowflake Secure Data Sharing supports sharing external tables (B) and secure UDFs (C), along with tables, secure views, and secure materialized views. External tables allow providers to share structured references to data stored in external cloud storage. Secure UDFs can be included in a share so consumers can call functions without seeing the underlying logic. Files (A) cannot be shared as a database object through data sharing-they live in stages, not as shareable schema objects. Sequences (D) cannot be shared because they generate values locally per account and sharing them would not be meaningful. Streams (E) cannot be shared because they are stateful change-tracking objects tied to the provider account's transaction log.

Topics

#Secure Data Sharing#Database Objects#External Tables#UDFs

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice