ExamGecko
Question list
Search
Search

Question 532 - SnowPro Core discussion

Report
Export

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?

A.

External

Answers
A.

External

B.

Permanent

Answers
B.

Permanent

C.

Temporary

Answers
C.

Temporary

D.

Transient

Answers
D.

Transient

Suggested answer: D

Explanation:

The type of Snowflake table that persists until it is explicitly dropped, is available for all users with relevant privileges across sessions, and does not have a Fail-safe period, is a Transient table. Transient tables are designed to provide temporary storage similar to permanent tables but with some reduced storage costs and without the Fail-safe feature, which provides additional data protection for a period beyond the retention time. Transient tables are useful in scenarios where data needs to be temporarily stored for longer than a session but does not require the robust durability guarantees of permanent tables.

asked 29/10/2024
krishamrock krishqmrock
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first