Free Preparation Discussions
MENU
Snowflake ADA-C01 Exam - Topic 5 Question 32 Discussion
Topic #: 5
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?
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.
Lelia
4 months agoNan
4 months agoTran
4 months agoMargery
4 months agoGearldine
4 months agoMadelyn
5 months agoTequila
5 months agoBrandon
5 months agoGeraldo
5 months agoNovella
5 months agoSylvie
5 months agoPilar
5 months agoDominic
5 months agoJesusa
10 months agoAnika
10 months agoLaura
9 months agoIvan
9 months agoTresa
10 months agoGlenna
11 months agoRobt
9 months agoCarisa
9 months agoMa
9 months agoGlenna
10 months agoNoemi
11 months agoBen
11 months agoEttie
11 months agoMillie
11 months agoTiffiny
10 months agoCyndy
10 months agoMarge
10 months agoHarrison
11 months agoBea
11 months agoErin
11 months agoSkye
12 months ago