A user needs to MINIMIZE the cost of large tables that are used to store transitory dat

The correct answer is B. Permanent. Permanent tables incur both Time Travel storage costs (up to 90 days) and Fail-safe storage costs (an additional 7 days), making them the most expensive option. For transitory data that can be reconstructed if lost, users should avoid Permanent tables. Transient tables…

Storage and Data Protection

Question

Options

AThe data does not need to be protected against failures, because the data can be reconstructed
BPermanent
CTransient
DTemporary
EExterna

How the community answered

(37 responses)

B
81% (30)
C
5% (2)
D
11% (4)
E
3% (1)

Explanation

Permanent tables incur both Time Travel storage costs (up to 90 days) and Fail-safe storage costs (an additional 7 days), making them the most expensive option. For transitory data that can be reconstructed if lost, users should avoid Permanent tables. Transient tables eliminate the Fail-safe period and reduce Time Travel to a maximum of 1 day, significantly lowering storage costs. Temporary tables are session-scoped and also avoid Fail-safe. Choosing Permanent tables for transitory, reconstructible data adds unnecessary storage overhead. Note: The question appears truncated in the source; this explanation reflects the standard Snowflake guidance on table type cost tradeoffs.

Topics

#Table Types#Cost Optimization#Storage Management#Data Lifecycle

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice