Free Preparation Discussions
MENU
Snowflake ADA-C01 Exam - Topic 7 Question 18 Discussion
Topic #: 7
A Snowflake Administrator needs to retrieve the list of the schemas deleted within the last two days from the DB1 database.
Which of the following will achieve this?
According to the Snowflake documentation1, a transient table is a type of table that does not support Time Travel or Fail-safe, which means that it does not incur any storage costs for maintaining historical versions of the data or backups for disaster recovery. A transient table can be dropped at any time, and the data is not recoverable. A transient table can also have a retention time of 0 days, which means that the data is deleted immediately after the table is dropped or truncated. Therefore, creating the staging table as a transient table with a retention time of 0 days can minimize the storage costs and maximize the performance, as the data is only loaded and transformed once, and then deleted after the production tables are populated. Option A is incorrect because creating the staging table as an external table, which references data files stored in a cloud storage location, can incur additional costs and complexity for data transfer and synchronization, and may not provide the best performance for data loading and transformation. Option C is incorrect because creating the staging table as a temporary table, which is automatically dropped when the session ends or the user logs out, can cause data loss or inconsistency if the session is interrupted or terminated before the production tables are populated. Option D is incorrect because creating the staging table as a permanent table, which supports Time Travel and Fail-safe, can incur additional storage costs for maintaining historical versions of the data and backups for disaster recovery, and may not provide the best performance for data loading and transformation.
Tu
3 months agoSanda
3 months agoEun
3 months agoDenae
4 months agoGerald
4 months agoAileen
4 months agoTalia
4 months agoMaryann
4 months agoMi
5 months agoGeraldo
5 months agoLindsey
5 months agoMargurite
5 months agoReena
5 months agoFloyd
5 months agoCasandra
5 months agoTashia
5 months agoStefany
10 months agoTonette
10 months agoMicah
8 months agoAbraham
8 months agoMerilyn
8 months agoMisty
8 months agoParis
8 months agoElliot
9 months agoGrover
10 months agoGail
9 months agoSanjuana
10 months agoMa
10 months agoLacey
11 months agoClaudio
9 months agoChauncey
9 months agoJunita
10 months agoColton
10 months agoTamesha
11 months agoDelfina
11 months agoTamesha
11 months ago