COF-C03 practice question 7 of 10
True or False: Fail-safe can be disabled within a Snowflake account.
Full set: 1,126 questionsThe statement is false. Fail-safe is a data recovery service provided by Snowflake that cannot be disabled or configured by account administrators or users. It is an integral part of the Snowflake data storage architecture, providing a non-configurable 7-day period for data recovery after the Time Travel retention period has ended. This feature is managed entirely by Snowflake to ensure a level of data protection against catastrophic data loss.
The option "True" is incorrect because user-configurable data retention is limited to the Time Travel feature (0-90 days depending on the edition). Fail-safe is a separate, subsequent, and non-configurable recovery mechanism.
1. Snowflake Documentation. "Understanding & Viewing Fail-safe". This page explicitly states: "The Fail-safe period is not configurable by the user." and "Fail-safe is not a feature that is intended for accessing historical data. Instead, it is for disaster recovery of data that has been lost or damaged due to extreme operational failures."
2. Snowflake Documentation. "Storage Costs for Time Travel and Fail-safe". In the overview table, the "Configurable by user?" row for Fail-safe is marked "No". This confirms that users have no control over enabling or disabling this feature.
Keep practicing
Take the free COF-C03 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-C03 practice questions
- Question 1What is the primary purpose for configuring multiple Identity Providers, or IdPs, in Snow…
- Question 2At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
- Question 3Which commands are restricted in owner's rights stored procedures? (Select TWO).
- Question 4Which views are included in the DATA SHARING USAGE schema? (Select TWO).
- Question 5Snowflake's access control framework combines which models for securing data? (Select TWO…
- Question 6True or False: Loading data into Snowflake requires that source data files be no larger t…
