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

Question

A Snowflake account has the 'DATA RETENTION TIME IN DAYS' parameter set to the maximum allowed value for Enterprise Edition. A user executes a large DELETE statement against a table, removing 90% of its rows. After 60 days, they realize they need to recover the deleted data. Which of the following statements is CORRECT regarding the feasibility of recovering the data using Time Travel?

Options

• AThe data can be recovered using Time Travel because the 'DATA RETENTION TIME IN DAYS'
• BThe data cannot be recovered because the default retention period is only 1 day. The maximum
• CThe data can be recovered, but only if the parameter was explicitly set to extend the retention
• DThe data can be recovered, assuming the parameter was explicitly set to a value greater than or

Explanation

The 'DATA RETENTION TIME IN DAYS parameter needs to be explicitly set at the account, database, or table level for the desired retention period to be effective. If the parameter isn't set, the default retention period is used. Setting it to the maximum value without applying it to the relevant scope has no effect. It's important to note that Business Critical Edition can have up to 90 days of retention.

No community discussion yet for this question.