Answer: Temporary Tables, Transient Tables

The question asks for two mechanisms Snowflake provides to reduce data storage costs for short-lived tables. Temporary Tables (A) are automatically dropped at the end of the session and do not contribute to long-term storage costs. Transient Tables (B) are similar but persist until explicitly dropped, though they have a shorter time travel retention period (1 day vs. up to 90 days for permanent tables), reducing storage overhead. Provisional Tables (C) is not a valid Snowflake table type, and Permanent Tables (D) are the default with full time travel retention, making them unsuitable for cost reduction. The community discussion strongly supports AB, with 88% of users selecting it and multiple comments affirming A and B as correct, while no credible support exists for other combinations.

Author: LeetQuiz Editorial Team