SnowPro Core Certification — Question 906

Which Snowflake table type persists until it is explicitly dropped, is available for all users with relevant privileges (across sessions), and has no Fail-safe period?

Answer options

• A. External
• B. Permanent
• C. Temporary
• D. Transient

Correct answer: D

Explanation

The correct answer is D, Transient, as these tables are designed to persist without a Fail-safe period, making them available to users across sessions until deleted. Option A, External, refers to tables that store data outside of Snowflake and have different usage scenarios. Option B, Permanent, retains data indefinitely with a Fail-safe period, and Option C, Temporary, only lasts for the duration of the session, which does not fulfill the criteria.