01. Which feature in Snowflake allows users to see historical data?

02. What is the default Time Travel retention period for a permanent table in Snowflake (Standard Edition)?

03. What is the maximum Time Travel retention period available in Snowflake (Enterprise Edition or higher)?

04. What happens to dropped tables after the Time Travel retention period expires?

05. Which table types do not support Time Travel in Snowflake? [Select 2]

06. What is the maximum Time Travel retention for a Permanent Table?

07. What command is used to restore a dropped table within the Time Travel period?

08. What is the duration of the Fail-safe period in Snowflake?

09. Can users access data during the Fail-safe period?

10. Which of the following is true about Transient Tables and Fail-safe?

11. What is the benefit of Time Travel in Snowflake?

12. What is required to enable 90-day Time Travel in Snowflake?

13. A developer creates a database named SALES_DB containing multiple schemas and tables. The developer wants to know whether Snowflake provides a Fail-safe feature at the database level, allowing the entire database to be recovered during the Fail-safe period. Which of the following statements is correct?

14. A table has a Time Travel retention period of 1 day. Data is deleted on Monday. On Thursday, the retention period is increased to 90 days. Can the deleted data be recovered?

15. A database has a retention period of 30 days. After 60 days, the retention period is increased to 60 days. What happens to historical data older than 30 days?

16. What happens once the Time Travel period has ended for Permanent tables?

17. Can Fail-safe be disabled or reduced for Permanent tables?

18. Which clause is used to set the Time Travel retention period while creating a table?

19. What determines the storage cost associated with Time Travel data?

20. What keyword is used in SQL to query historical data using Time Travel?