
Answer-first summary for fast verification
Answer: Temporary
The question asks which Snowflake table type minimizes costs in ETL workflows. Temporary tables (C) are the most cost-effective because they do not incur storage costs and are automatically purged at the end of the session, avoiding long-term storage charges. While transient tables (D) also avoid Time Travel and Fail-safe costs, they persist until explicitly dropped, potentially incurring storage costs if not managed properly. ETL workflows often involve intermediate data that doesn't need persistence beyond the session, making temporary tables ideal for cost reduction. The community discussion shows a split, but the higher upvotes and reasoning for C (e.g., 'they do not incur any storage costs') align with Snowflake best practices for minimizing costs in transient processing like ETL.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.