SOL-C01 Question #216: Real Exam Question with Answer & Explanation

Question

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?

Options

• AEnable replication across multiple regions to protect against regional outages and ensure data
• BSet the `DATA RETENTION TIME IN DAYS' parameter to a sufficiently long period (e.g., 90 days)
• CSet the `DATA RETENTION TIME IN DAYS' parameter at the account level to a sufficient value,
• DRely solely on Fail-safe as this guarantees long-term data recovery and provides automated

Explanation

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.

No community discussion yet for this question.