SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ26

Perform database monitoring, tuning, and optimization

An Administrator loads data into a staging table each day. After it is loaded, users from several different departments transform the data and load it into different production tables.

How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

Explanation

A transient table persists until explicitly dropped and is available to users with the required privileges, unlike a temporary table, which exists only for its creating session. Transient tables have no Fail-safe period; setting their Time Travel retention to 0 eliminates retained historical data, minimizing storage costs while retaining an internal table suitable for staging and transformation work. Working with Temporary and Transient Tables

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!