Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 900

What do temporary and transient tables have in common in Snowflake? (Choose two.)

    Correct Answer: A, B

    Both temporary and transient tables in Snowflake have no Fail-safe period, and both have data retention period maximums of one day. Temporary tables do not persist beyond the session for temporary tables, but that is not something common with transient tables. Therefore, the correct answers relate to both the absence of a Fail-safe period and the one-day maximum retention period for both table types.

Discussion
gizzamoOptions: AB

A and B are correct. https://docs.snowflake.com/user-guide/tables-temp-transient#comparison-of-table-types

Pradeep_7869Options: BD

B because it is asking for max retention days. and for both the table max retention can be 1 days in enteprise

umidjon03Options: AB

AB is correct

ohohfourtwentyOptions: AB

AB is right

snow101Options: AB

a b is ok

Isio05Options: AB

AB is correct

ASK_123Options: AB

AB is correct.

BobFarOptions: AB

AB is correct. No fail safe for both Max 1 day time travel for both https://docs.snowflake.com/en/user-guide/tables-temp-transient#comparison-of-table-types

HeetecOptions: AB

A for sure...B??

BobFar

B is correct too https://docs.snowflake.com/en/user-guide/tables-temp-transient#comparison-of-table-types

Heetec

OK, thanks :)

Pradeep_7869Options: AB

AB is correct