Configure Cloning and Data Retention DEA-C02 Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which use case is most appropriate for a transient clone?

   • ACreating a temporary copy of a table for a one-time data transformation that will be dropped after the job.
   • BCloning a production database to provide a development environment that must match production fail-safe.
   • CCloning a table to test a new feature where data loss is acceptable but the clone must survive a region failure.
   • DCreating a long-term archive of financial records that must be retained for seven years.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which characteristic is true for a transient clone in Snowflake?

   • AIt has the same fail-safe period as the source object.
   • BIt is not protected by fail-safe and has a lower storage cost.
   • CIt can be cloned only from a transient source object.
   • DIt is automatically converted to a permanent clone after 30 days.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A data engineer is designing a disaster recovery strategy for a critical permanent table. The engineer wants to ensure that data can be recovered for as long as possible after accidental deletion, without any additional configuration beyond what Snowflake provides by default. Which statement correctly describes the fail-safe period for this table?

   • AFail-safe provides 0 days of recovery because it must be explicitly enabled
   • BFail-safe provides 7 days of recovery after the time travel window expires
   • CFail-safe provides 1 day of recovery after the time travel window expires
   • DFail-safe provides 90 days of recovery after the time travel window expires
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A company is evaluating storage costs for a new application. The application will use a mix of permanent and transient tables. The data engineer needs to explain the fail-safe implications to the finance team. Which statement accurately describes fail-safe for transient tables?

   • ATransient tables have a 1-day fail-safe period
   • BTransient tables have a configurable fail-safe period
   • CTransient tables have no fail-safe period
   • DTransient tables have a 7-day fail-safe period, same as permanent tables
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What happens to the time travel history of a clone when the source table is dropped?

   • AThe clone inherits the source's time travel history.
   • BThe clone loses its time travel history.
   • CThe clone retains its own time travel history.
   • DThe clone's time travel is disabled.
   Reveal Solution Discussion Select an answer first