Exam SOL-C01 Topic 1 Question 83 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 83
Topic #: 1

A data warehouse contains a table 'SALES TRANSACTIONS that is frequently updated. You need to ensure that the data is protected against accidental deletions and updates, and you need to be able to restore the data to a specific point in time. Which of the following Snowflake features and configurations should you implement to achieve this goal effectively?

A. Set the `DATA RETENTION TIME IN DAYS' parameter at the account level to a sufficient value, and understand that Fail-safe provides an additional layer of protection, although not directly accessible. B. Rely solely on Fail-safe as this guarantees long-term data recovery and provides automated recovery capabilities. Set Data Retention parameter to 1. C. Enable replication across multiple regions to protect against regional outages and ensure data availability. This is the only protection required. D. Set the `DATA RETENTION TIME IN DAYS' parameter to a sufficiently long period (e.g., 90 days) and regularly create backups using Snowflake's data export feature.

Suggested Answer: A Vote an answer

Setting the parameter enables Time Travel, which allows restoring data to a specific point in the past within the retention period. Fail-safe provides an additional layer of protection beyond Time Travel, but it's not directly accessible for user- initiated recovery. Replication (Option A) is for disaster recovery but doesn't help with user errors. Backups (Option B) are useful but add complexity compared to Time Travel. Option D relies solely on Fail-safe, which is not user- accessible. Note, it is best to only provide time travel on required databases to save money on storage costs, account level might be unnecessary. Therefore, C is still better option than setting at table level also.

by Lucy at Mar 11, 2026, 02:35 PM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business