DP-750: Implementing Data Engineering Solutions Using Azure DatabricksDemo

By Microsoft · Question Mode

QuestionQ24

Prepare and process data

You have an Azure Databricks workspace that includes a Delta table named Table1.

Table1 has accumulated obsolete files. You need to reduce storage costs while preserving 30 days of time-travel history.

Which two actions should you take? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Choose two
  • A Run the vacuum command on Table1.
  • B Set the delta.deletedFileRetentionDuration table property to 30 days.
  • C Set the delta.logRetentionDuration table property to 30 days.
  • D Run the OPTIMIZE command on Table1.
  • E Reduce the deleted file retention period to one day.
Explanation

Set delta.deletedFileRetentionDuration to 30 days so that obsolete Delta data files remain available for the required 30-day time-travel window. Run VACUUM on the table to permanently delete obsolete files older than that retention period, reducing storage costs. The Delta transaction-log retention setting does not preserve the old data files required for time travel after a vacuum operation.

Learn more

Community Discussion

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