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

Questions 16–20

1. 16foundation · easy

   What is the duration of the fail-safe period for permanent tables in Snowflake?

   • A7 days
   • B1 day
   • C30 days
   • D90 days
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A financial services company must be able to query data as it existed 5 days ago for audit purposes. The account-level DATA_RETENTION_TIME_IN_DAYS is set to 1. The database containing the critical table has DATA_RETENTION_TIME_IN_DAYS set to 3. The table itself has no explicit retention setting. What is the maximum time travel window available for this table?

   • A3 days, because the table inherits the database-level setting
   • B1 day, because the account-level setting is the default for all objects
   • C0 days, because the table has no explicit retention setting
   • D5 days, because the audit requirement dictates the retention period
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   When a table is cloned, what is the time travel retention period of the clone?

   • AIt is set to the default of 1 day.
   • BIt is set to 0 days.
   • CIt inherits the source table's retention period.
   • DIt is set to the maximum of 90 days.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   If a schema has DATA_RETENTION_TIME_IN_DAYS set to 3, and a table in that schema does not have the parameter set, what is the table's retention period?

   • A7 days
   • B0 days
   • C3 days
   • D1 day (the default)
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   What is the storage behavior of a clone immediately after creation?

   • AThe clone stores only the metadata of the source table.
   • BThe clone shares storage with the source and only stores new data when changes are made.
   • CThe clone stores a full copy of the source data.
   • DThe clone stores a compressed copy of the source data.
   Reveal Solution Discussion Select an answer first