Answer: Temporary tables, Transient tables

The question asks for table types used to manage costs for short-lived tables. Temporary tables (D) are automatically dropped at the end of the session and incur no storage costs after the session ends, making them ideal for temporary data. Transient tables (E) have a lower data protection level (no Time Travel by default) and reduced fail-safe period, resulting in lower storage costs compared to permanent tables, making them suitable for transient data that doesn't require full data protection. External tables (A) reference data stored externally in cloud storage, not managed within Snowflake, so they don't directly help with cost management for short-lived tables. Permanent tables (B) have full data protection features (Time Travel, fail-safe) and higher storage costs, making them unsuitable for cost management with short-lived data. Shared tables (C) are for data sharing scenarios and don't specifically address cost management for short-lived tables. The community discussion with 100% consensus on DE and reference to Snowflake documentation confirms this selection.

Author: LeetQuiz Editorial Team