Answer: Transient

The question asks for the table type that minimizes cost for large tables containing transitory data that doesn't require failure protection and can be recreated externally. Transient tables (B) are specifically designed for this scenario as they have no fail-safe period, which reduces storage costs significantly. The community discussion strongly supports this with 100% consensus for B, and multiple comments reference Snowflake documentation confirming transient tables are optimal for cost-sensitive scenarios with recoverable data. Permanent tables (A) include fail-safe protection, increasing costs unnecessarily. Temporary tables (C) are session-scoped and not suitable for persistent transitory data. External tables (D) reference data outside Snowflake but don't provide the same cost optimization for data stored within Snowflake.

Author: LeetQuiz Editorial Team