nerdexam
Snowflake

COF-C02 · Question #85

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

The correct answer is D. 24 hours. Continuous Data Protection (CDP) costs come from two components: Time Travel and Fail-safe. Temporary tables have a maximum Time Travel retention period of 1 day (24 hours), and - critically - they have zero Fail-safe period (0 days). Therefore, the maximum total CDP charge for…

Storage and Data Protection

Question

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

Options

  • A30 days
  • B7 days
  • C48 hours
  • D24 hours

How the community answered

(51 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    4% (2)
  • D
    92% (47)

Explanation

Continuous Data Protection (CDP) costs come from two components: Time Travel and Fail-safe. Temporary tables have a maximum Time Travel retention period of 1 day (24 hours), and - critically - they have zero Fail-safe period (0 days). Therefore, the maximum total CDP charge for a temporary table is 24 hours. This is unlike permanent tables, which can have up to 90 days of Time Travel (Enterprise+) plus 7 days of Fail-safe. Temporary tables also only exist for the duration of the session.

Topics

#Continuous Data Protection#Temporary tables#Time Travel#Data retention policy

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice