exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 703 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 703
Topic #: 1
[All SnowPro Core Questions]

What are characteristics of transient tables in Snowflake? (Choose two.)

  • A. Transient tables have a Fail-safe period of 7 days.
  • B. Transient tables can be cloned to permanent tables.
  • C. Transient tables persist until they are explicitly dropped.
  • D. Transient tables can be altered to make them permanent tables.
  • E. Transient tables have Time Travel retention periods of 0 or 1 day.
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
MultiCloudIronMan
3 months ago
Selected Answer: BC
"Transient tables do not have a Fail-safe period. They are designed to minimize storage costs by not retaining historical data." > "Transient tables can be cloned to create permanent tables." > "Transient tables persist until they are explicitly dropped by the user." > "Transient tables cannot be altered to become permanent tables. You would need to create a new permanent table and migrate the data." > "Transient tables have a Time Travel retention period of either 0 or 1 day."
upvoted 1 times
...
nonamae
6 months, 2 weeks ago
Selected Answer: CE
see the comparison of table types - https://docs.snowflake.com/en/user-guide/tables-temp-transient
upvoted 3 times
...
rajukg
7 months ago
B does not make sense.
upvoted 1 times
...
pvskbrod
7 months, 1 week ago
Selected Answer: CE
Transient => Temporary Transient => Transient
upvoted 1 times
...
JG1984
7 months, 2 weeks ago
Selected Answer: CE
Transient tables are a type of table in Snowflake that persist until they are explicitly dropped. They do not have a Fail-safe period, and they can only have a Time Travel retention period of 0 or 1 day. Transient tables cannot be cloned to permanent tables, and they cannot be altered to make them permanent tables.
upvoted 3 times
...
fannaa
7 months, 3 weeks ago
Selected Answer: BE
correct https://docs.snowflake.com/user-guide/tables-temp-transient#comparison-of-table-types
upvoted 1 times
...
MultiCloudIronMan
9 months, 1 week ago
Selected Answer: CE
https://www.bing.com/search?q=What+are+characteristics+of+transient+tables+in+Snowflake%3F&qs=n&form=QBRE&sp=-1&lq=0&pq=what+are+characteristics+of+transient+tables+in+snowflake%3F&sc=1-58&sk=&cvid=82C0B06F8F6B402FABAB2E7EC1CFAAAF&ghsh=0&ghacc=0&ghpl=
upvoted 1 times
...
happykeieiekek
9 months, 1 week ago
Answer is C & E
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago