The use of which Snowflake table type will reduce costs when working with ETL workflows?
The use of which Snowflake table type will reduce costs when working with ETL workflows?
Transient tables are the most cost-effective option for ETL workflows in Snowflake. This is because transient tables do not incur the additional costs associated with fail-safe storage. Transient tables are designed for intermediate data that is not needed for long-term recovery, making them ideal for ETL processes where data is processed and moved quickly. Permanent tables, on the other hand, have higher storage costs due to fail-safe mechanisms, and temporary tables are session-specific and do not persist beyond the session's end.
correct
Answer is C: https://docs.snowflake.com/en/user-guide/tables-temp-transient Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data).
It's D, not C. The question tells us about ETL. You are using Transient with ETL not Temporary, and the cost will be be also reduce with Transient
Also Think it's D
My understanding is Transient will be the more suitable answer as this table will be used during the ETL operations on the contrary Temp tables are session-oriented and used for temporary purposes although Transient tables reside and are available after ETL ops and as they are not fail-safe and 0-1 day of time-travel so quite economical then Permamanet