Snowflake SnowPro Certification Practice Test

Disable ads (and more) with a membership for a one time $4.99 payment

Prepare for the Snowflake SnowPro Certification exam with flashcards and multiple choice questions. Understand each question with detailed hints and explanations. Ace your test!

Practice this question and more.

What type of table can be shared between different Snowflake accounts?

Permanent Tables
Temporary Tables
External Tables
Transient Tables

The correct answer is: External Tables

External tables are designed to enable access to data stored in external locations like Amazon S3 or Microsoft Azure Blob Storage, and they can be shared between different Snowflake accounts. This characteristic of external tables allows organizations to collaborate or share data without needing to copy or import it directly into their account, promoting efficiency and reducing storage costs. In contrast, permanent tables are specific to a given Snowflake account and cannot be directly shared across accounts. Temporary tables, on the other hand, are session-specific and persist only for the duration of a user's session, hence they cannot be shared between accounts due to their ephemeral nature. Transient tables are similar to permanent tables in that they are stored within the account but lack the durability and time travel features of permanent tables; they too cannot be shared across different accounts. Hence, external tables are the correct option for sharing data across Snowflake accounts.