Manage Time Travel and Fail-Safe DEA-C02 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A data engineer is trying to recover data from a table that was dropped 10 days ago. The account has a Time Travel retention of 7 days. The engineer attempts to use UNDROP but receives an error. What is the most likely reason for the error?

   • AThe table is now in Fail-safe, which is not user-accessible.
   • BThe user lacks the necessary privileges to UNDROP the table.
   • CThe table name is case-sensitive and was entered incorrectly.
   • DThe table was permanently deleted and cannot be recovered.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is the maximum Time Travel retention period that can be configured for a table in Snowflake?

   • A7 days
   • B30 days
   • C90 days
   • D1 day
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   If DATA_RETENTION_TIME_IN_DAYS is set to 5 at the database level and 10 at the schema level, what is the effective retention for a new table created in that schema?

   • AThe table-level setting is required
   • B5 days
   • C10 days
   • D15 days
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   What is the effect of increasing the DATA_RETENTION_TIME_IN_DAYS parameter on storage costs?

   • AStorage costs increase because more historical data is retained
   • BStorage costs decrease because data is compressed more
   • CStorage costs are unpredictable
   • DStorage costs remain the same because Time Travel is free
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A company is evaluating the storage cost impact of increasing the Time Travel retention period from 1 day to 7 days for a large table that undergoes frequent updates. Which statement accurately describes the cost implication?

   • AStorage costs will decrease because Time Travel compresses data.
   • BStorage costs will remain the same because Time Travel uses the same storage as the current table.
   • CStorage costs will only increase if the table is dropped.
   • DStorage costs will increase because Time Travel retains historical versions of data for a longer period.
   Reveal Solution Discussion Select an answer first