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

Questions 11–15

1. 11expert · medium

   A company is on Snowflake Enterprise edition. They have a table that is updated frequently, and they want to set the Time Travel retention to 90 days. However, they are concerned about the storage cost. Which approach would be most cost-effective while meeting the 90-day retention requirement?

   • ASet DATA_RETENTION_TIME_IN_DAYS = 90 on the schema.
   • BSet DATA_RETENTION_TIME_IN_DAYS = 90 on the database.
   • CUse a separate table to store historical snapshots and set the original table's retention to 1 day.
   • DSet DATA_RETENTION_TIME_IN_DAYS = 90 on the table.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A company accidentally dropped a critical table and did not realize it until 10 days later. The account has a Time Travel retention of 7 days. The data is now in Fail-safe. What is the correct process to recover the data?

   • AContact Snowflake support and request a Fail-safe recovery.
   • BUse the AT clause with a timestamp before the drop.
   • CRestore from a backup taken before the drop.
   • DRun UNDROP TABLE with a FORCE option.
   Reveal Solution Discussion Select an answer first
4. 13expert · medium

   A user accidentally dropped a database that contained multiple schemas and tables. The database was dropped 5 days ago, and the account has a Time Travel retention of 7 days. The user wants to restore the database and all its objects. What is the correct action?

   • ARun CREATE DATABASE database_name CLONE database_name BEFORE (DROP);
   • BRun UNDROP SCHEMA for each schema in the database.
   • CContact Snowflake support to restore from Fail-safe.
   • DRun UNDROP DATABASE database_name;
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What does the CLONE command with AT or BEFORE do in Snowflake?

   • ADeletes an object and all its data
   • BCreates a copy of an object as it existed at a specified point in time
   • CMoves an object to a different database
   • DRestores an object from Fail-safe
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What is a constraint of Fail-safe data recovery?

   • AIt can be performed at any time
   • BIt may take several days to complete
   • CIt is initiated by the user
   • DIt can be done for individual rows
   Reveal Solution Discussion Select an answer first