Which Snowflake table objects can be shared with other accounts? (Choose two.)
Which Snowflake table objects can be shared with other accounts? (Choose two.)
Permanent tables and external tables can be shared with other accounts in Snowflake. Temporary and transient tables are not designed for sharing as they have limited lifespan and specific scopes of visibility. User-Defined Table Functions (UDTFs) are procedural and not table objects, hence they are also not shareable in the context described.
"Secure Data Sharing lets you share selected objects in a database in your account with other Snowflake accounts. You can share the following Snowflake objects: Databases Tables Dynamic tables External tables Iceberg tables Secure views Secure materialized views Secure user-defined functions (UDFs)"
The Correct Answer is BD
BD You can share tables and external tables, although I cannot find info whether you can share temporary or transient tables. For sure it is BD, I do not know about transient tables.
The Correct Answer is B C