Which object can be used with Secure Data Sharing?

The correct answer is A. View. In Snowflake Secure Data Sharing, views - specifically SECURE views - are a supported shareable object type. Secure views are the recommended way to expose specific rows and columns of underlying tables to data consumers without granting direct table access. Regular…

Data Protection and Data Sharing

Question

Options

AView
BMaterialized view
CExternal table
DUser-Defined Function (UDF)

How the community answered

(21 responses)

A
90% (19)
B
5% (1)
C
5% (1)

Explanation

In Snowflake Secure Data Sharing, views - specifically SECURE views - are a supported shareable object type. Secure views are the recommended way to expose specific rows and columns of underlying tables to data consumers without granting direct table access. Regular (non-secure) materialized views and UDFs cannot be added to a share; only their SECURE counterparts can. While external tables also have sharing support, the standard, widely-tested object for controlled data exposure in a share is the secure view.

Topics

#Secure Data Sharing#Data Sharing#Views#Snowflake Objects

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice