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

Questions 1–5

1. 1foundation · easy

   Which of the following can be used with the AT or BEFORE clause to specify a point in Time Travel?

   • AStatement ID or query ID
   • BOffset or session ID
   • CTimestamp or transaction ID
   • DTimestamp, offset, or statement ID
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   How does accessibility differ between Time Travel and Fail-safe?

   • ATime Travel requires support, while Fail-safe is user-accessible
   • BBoth require Snowflake support
   • CBoth are user-accessible
   • DTime Travel is user-accessible, while Fail-safe requires Snowflake support
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data engineer accidentally dropped a schema named HR. The schema contained multiple tables. The engineer wants to restore the schema and all its tables to the state just before the drop. The Time Travel retention is 7 days. What is the most efficient way to do this?

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

   At which levels can the DATA_RETENTION_TIME_IN_DAYS parameter be set in Snowflake?

   • AAccount, warehouse, and table
   • BAccount and table only
   • CAccount, database, schema, and table
   • DDatabase, schema, and view
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A user accidentally dropped a table named CUSTOMER_DATA. The table was created 10 days ago and the account has a Time Travel retention of 14 days. The user wants to restore the table as quickly as possible. What should the user do?

   • ARun CREATE TABLE customer_data CLONE customer_data BEFORE (DROP);
   • BRun SELECT * FROM customer_data AT (OFFSET => -86400);
   • CRun UNDROP TABLE customer_data;
   • DContact Snowflake support to restore the table from Fail-safe.
   Reveal Solution Discussion Select an answer first