COF-C02 · Question #181
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
The correct answer is A. Schemas C. Secure Views F. Secure User-Defined Functions (UDFs). Snowflake Secure Data Sharing allows accounts to share read-only access to specific objects without copying data. The shareable objects are: tables, external tables, secure views, secure materialized views, secure UDFs, and schemas. Schemas (A), Secure Views (C), and Secure…
Question
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
Options
- ASchemas
- BRoles
- CSecure Views
- DStored Procedures
- ETables
- FSecure User-Defined Functions (UDFs)
How the community answered
(25 responses)- A92% (23)
- B4% (1)
- D4% (1)
Explanation
Snowflake Secure Data Sharing allows accounts to share read-only access to specific objects without copying data. The shareable objects are: tables, external tables, secure views, secure materialized views, secure UDFs, and schemas. Schemas (A), Secure Views (C), and Secure UDFs (F) are all valid shareable objects. Roles (B) cannot be shared across accounts - each account manages its own role hierarchy. Stored Procedures (D) are not shareable objects. Note: regular (non-secure) views and UDFs are not shareable because they could expose underlying data or logic; only the 'secure' variants qualify.
Topics
Community Discussion
No community discussion yet for this question.