
Answer-first summary for fast verification
Answer: Permanent tables, External tables
The question asks which Snowflake table objects can be shared with other accounts, requiring selection of two options. Based on Snowflake's Secure Data Sharing documentation and the community discussion consensus (with BD receiving 100% agreement and the highest upvotes), permanent tables (B) and external tables (D) are the correct choices. Permanent tables can be shared as they persist across sessions and are designed for data sharing scenarios. External tables (D) can also be shared since they reference external data sources while maintaining Snowflake's metadata and access control. Temporary tables (A) are session-scoped and automatically dropped, making them unsuitable for sharing. Transient tables (C) have a limited retention period and are not designed for secure data sharing. User-Defined Table Functions (UDTFs) (E) are functions, not table objects, and while secure UDTFs exist, they are not table objects that can be directly shared like tables.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.