Answer: Temporary tables, Transient tables

The question asks which Snowflake objects reduce data storage costs for short-lived tables, requiring two answers. Temporary tables (B) and transient tables (C) are designed for this purpose. Temporary tables exist only for the session and incur no storage costs after the session ends, while transient tables have no Fail-safe period (unlike permanent tables), reducing storage costs for short-lived data. Provisional tables (A) are not a standard Snowflake object. Permanent tables (D) include Fail-safe, increasing costs. Lookup tables (E) are a use case, not a table type, and do not inherently reduce costs. The community discussion unanimously supports BC with 100% agreement and upvotes, confirming this as the correct choice based on Snowflake's table types and cost optimization features.

Author: LeetQuiz Editorial Team