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

Questions 11–15

1. 11foundation · easy

   What happens to the storage of a clone when a row is updated in the clone?

   • AThe clone writes the updated row to its own storage, leaving the source unchanged.
   • BThe clone becomes a full copy of the source after the update.
   • CThe clone and source share the updated row in the same storage.
   • DThe source table is updated to reflect the change in the clone.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   How does increasing the time travel retention period affect storage costs?

   • AIt increases compute costs but not storage costs.
   • BIt decreases storage costs because data is compressed more.
   • CIt increases storage costs because more historical data is retained.
   • DIt has no impact on storage costs.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   At which levels can the DATA_RETENTION_TIME_IN_DAYS parameter be set?

   • AAccount, database, and schema only
   • BDatabase and schema only
   • CAccount, database, schema, and table
   • DAccount and table only
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   How does cloning a table affect the clone's time travel capability?

   • AThe clone inherits the source's time travel history.
   • BThe clone cannot use time travel because it is a clone.
   • CThe clone's time travel history is identical to the source's history.
   • DThe clone has its own time travel history starting from the clone creation time.
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A data engineer clones a permanent table with DATA_RETENTION_TIME_IN_DAYS = 7. The clone is created at 9:00 AM. At 9:30 AM, the engineer drops the clone. At 10:00 AM, the engineer attempts to query the dropped clone using AT(TIMESTAMP => '9:15 AM'). Which statement correctly describes the outcome?

   • AThe query succeeds but only returns data from the source table, not the clone
   • BThe query fails because dropped clones cannot be queried using time travel
   • CThe query fails because the clone's retention period is only 1 day by default
   • DThe query succeeds because the clone inherits the source's 7-day retention
   Reveal Solution Discussion Select an answer first