Secured Data Sharing is allowed for which Snowflake database objects? (Select TWO).

The correct answer is A. Tables C. Secure views. Snowflake Secure Data Sharing supports sharing of: Tables (A), External tables, Secure views (C), Secure materialized views, and Secure UDFs/UDTFs. Regular (non-secure) views are excluded to prevent data leakage through view logic. Stored procedures (D) cannot be shared…

Data Protection and Data Sharing

Question

Options

ATables
BUser-Defined Table Functions (UDTFs)
CSecure views
DStored procedures
EWorksheets

How the community answered

(31 responses)

A
90% (28)
B
6% (2)
E
3% (1)

Explanation

Snowflake Secure Data Sharing supports sharing of: Tables (A), External tables, Secure views (C), Secure materialized views, and Secure UDFs/UDTFs. Regular (non-secure) views are excluded to prevent data leakage through view logic. Stored procedures (D) cannot be shared directly because they contain executable logic that could expose provider-side data structures. Worksheets (E) are a UI artifact and not a database object that can be shared. The 'Secure' designation on views ensures the view definition is hidden from the data consumer.

Topics

#Data Sharing#Secure Views#Tables#Snowflake Objects

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice