Which Snowflake objects can be used in a data share? (Select TWO).

The correct answer is B. Secure view D. External table. Snowflake Secure Data Sharing allows providers to share specific object types with consumer accounts. Secure views (B) are supported because they hide the underlying query logic from the consumer, protecting the provider's data model - standard (non-secure) views (A) are not allo

Data Governance and Data Sharing

Question

Options

AStandard view
BSecure view
CStored procedure
DExternal table
EStream

How the community answered

(42 responses)

A
2% (1)
B
95% (40)
C
2% (1)

Explanation

Snowflake Secure Data Sharing allows providers to share specific object types with consumer accounts. Secure views (B) are supported because they hide the underlying query logic from the consumer, protecting the provider's data model - standard (non-secure) views (A) are not allowed because consumers could potentially inspect the view definition and access unintended data. External tables (D) are supported in shares, allowing consumers to query data stored in external cloud storage. Stored procedures (C) cannot be included in a share because they contain executable logic, not data. Streams (E) cannot be shared because they are change-tracking objects tied to a specific account's transaction log and are not shareable constructs.

Topics

#Data Sharing#Snowflake Objects#Shareable Objects#Secure View

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice