SnowPro Core Certification — Question 510

Which Snowflake objects can be used to reduce data storage costs for short-lived tables? (Choose two.)

Answer options

• A. Provisional tables
• B. Temporary tables
• C. Transient tables
• D. Permanent tables
• E. Lookup tables

Correct answer: B, C

Explanation

Temporary tables and transient tables are designed specifically for short-term use, allowing for lower storage costs since they do not incur the same costs as permanent tables. Provisional tables are not a recognized Snowflake object, and lookup tables typically serve a different purpose, making them unsuitable for this context.