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

Questions 6–10

1. 6foundation · easy

   Which objects can be cloned using the CLONE command with Time Travel?

   • ATables and views only
   • BDatabases and warehouses only
   • CTables, schemas, and databases
   • DViews, stages, and warehouses
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   How is Fail-safe storage billed in Snowflake?

   • AIt is included in the standard storage cost
   • BIt is billed only when data is recovered
   • CIt is billed separately at a higher rate
   • DIt is free of charge
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   How is Time Travel storage billed in Snowflake?

   • AIt is billed separately at a fixed rate per day
   • BIt is billed only when data is accessed
   • CIt is free of charge
   • DIt is included in the standard storage cost
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is the purpose of Fail-safe in Snowflake?

   • ATo automatically replicate data to another region
   • BTo allow users to query historical data directly
   • CTo provide a 7-day recovery period after Time Travel ends
   • DTo provide a backup for data stored in external stages
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which command is used to restore a dropped table in Snowflake?

   • AUNDROP TABLE
   • BREVIVE TABLE
   • CRECOVER TABLE
   • DRESTORE TABLE
   Reveal Solution Discussion Select an answer first