nerdexam
Snowflake

COF-C02 · Question #666

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

The correct answer is C. Time Travel E. Fail-safe. Time Travel and Fail-safe are both part of Snowflake's Continuous Data Protection (CDP) framework and are enabled automatically. Time Travel allows querying and restoring historical data within a configurable retention window (up to 90 days on Enterprise). Fail-safe provides an…

Storage and Data Protection

Question

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Options

  • AInternal stages
  • BIncremental backups
  • CTime Travel
  • DZero-copy clones
  • EFail-safe

How the community answered

(31 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    87% (27)
  • D
    3% (1)

Explanation

Time Travel and Fail-safe are both part of Snowflake's Continuous Data Protection (CDP) framework and are enabled automatically. Time Travel allows querying and restoring historical data within a configurable retention window (up to 90 days on Enterprise). Fail-safe provides an additional 7-day recovery window managed exclusively by Snowflake after Time Travel expires. Internal stages are storage areas for data loading, zero-copy clones are a data duplication feature, and Snowflake does not use traditional incremental backups - none of these are CDP features.

Topics

#data protection#time travel#fail-safe#data recovery

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice