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
3 months agoNan
3 months agoTran
3 months agoMargery
4 months agoGearldine
4 months agoMadelyn
4 months agoTequila
4 months agoBrandon
4 months agoGeraldo
5 months agoNovella
5 months agoSylvie
5 months agoPilar
5 months agoDominic
5 months agoJesusa
9 months agoAnika
9 months agoLaura
9 months agoIvan
9 months agoTresa
9 months agoGlenna
10 months agoRobt
8 months agoCarisa
8 months agoMa
8 months agoGlenna
9 months agoNoemi
11 months agoBen
10 months agoEttie
10 months agoMillie
11 months agoTiffiny
9 months agoCyndy
9 months agoMarge
10 months agoHarrison
10 months agoBea
11 months agoErin
11 months agoSkye
11 months ago