Certified Data Analyst AssociateDemo

By Databricks · Question Mode

QuestionQ46

Managing Data

A data analyst configured a Delta table using the default retention settings. The analyst runs VACUUM operations weekly to control storage costs. A business user requests access to data from 10 days earlier for a compliance audit.

What happens to a time-travel query in this scenario?

  • A The time travel query will succeed because Delta Lake automatically backs up data for compliance purposes, regardless of VACUUM operations.
  • B The time travel query will succeed because the default log retention period is 30 days, which is sufficient to access 10-day-old data.
  • C The time travel query will fail because the default maximum table version is 7 and numbering resets after each VACUUM operation, making historical versions inaccessible.
  • D The time travel query will fail because the default data file retention period is 7 days, and VACUUM operations have likely removed the required data files.
Explanation

The default delta.deletedFileRetentionDuration is 7 days. A VACUUM operation can permanently remove obsolete data files older than that retention threshold, and time travel requires both the transaction log and the historical data files. The default 30-day log-retention period does not preserve time-travel capability after the necessary data files have been vacuumed.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!