The is the minimum Fail-safe retention time period for transient tables?

The correct answer is D. 0 days. Transient tables have a Fail-safe period of 0 days (D) - they have no Fail-safe protection at all. Fail-safe is an additional data recovery mechanism that operates after the Time Travel period expires. Permanent tables have a fixed 7-day Fail-safe period. Transient and…

Storage and Data Protection

Question

Options

A1 day
B7 days
C12 hours
D0 days

How the community answered

(23 responses)

B
4% (1)
C
4% (1)
D
91% (21)

Explanation

Transient tables have a Fail-safe period of 0 days (D) - they have no Fail-safe protection at all. Fail-safe is an additional data recovery mechanism that operates after the Time Travel period expires. Permanent tables have a fixed 7-day Fail-safe period. Transient and Temporary tables intentionally forego Fail-safe (and have limited Time Travel of 0–1 days) in exchange for lower storage costs, making them suitable for staging or non-critical data that does not require the extra data recovery guarantees.

Topics

#Fail-safe#Data Retention#Transient Tables#Table Types

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice