ExamGecko
Question list
Search
Search

Question 583 - SnowPro Core discussion

Report
Export

A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

What table type should be used?

A.

Permanent

Answers
A.

Permanent

B.

Transient

Answers
B.

Transient

C.

Temporary

Answers
C.

Temporary

D.

Externa

Answers
D.

Externa

Suggested answer: B

Explanation:

For minimizing the cost of large tables that are used to store transitory data, which does not need to be protected against failures because it can be reconstructed outside of Snowflake, the best table type to use is Transient. Transient tables in Snowflake are designed for temporary or transitory data storage and offer reduced storage costs compared to permanent tables. However, unlike temporary tables, they persist across sessions until explicitly dropped.

Why Transient Tables: Transient tables provide a cost-effective solution for storing data that is temporary but needs to be available longer than a single session. They have lower data storage costs because Snowflake does not maintain historical data (Time Travel) for as long as it does for permanent tables.

Creating a Transient Table:

To create a transient table, use the TRANSIENT keyword in the CREATE TABLE statement:

CREATE TRANSIENT TABLE my_transient_table (...);

Use Case Considerations: Transient tables are ideal for scenarios where the data is not critical, can be easily recreated, and where cost optimization is a priority. They are suitable for development, testing, or staging environments where data longevity is not a concern.

asked 29/10/2024
Martin Stoyanov
50 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first