DP-700 · Question #65
You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table in a lakehouse. You need to remove files that are older than seven days and are no…
The correct answer is A. VACUUM. To remove outdated and unused files from a Delta Lake table in a Lakehouse, specifically those older than a specified retention period, the VACUUM command is the appropriate choice.
Question
Options
- AVACUUM
- BCOMPUTE
- COPTIMIZE
- DCLONE
How the community answered
(36 responses)- A89% (32)
- B3% (1)
- C6% (2)
- D3% (1)
Why each option
To remove outdated and unused files from a Delta Lake table in a Lakehouse, specifically those older than a specified retention period, the VACUUM command is the appropriate choice.
The VACUUM command is used in Delta Lake to remove data files that are no longer referenced by the table's current or specified versions and are older than the retention threshold. This action helps reclaim storage space and improve query performance by cleaning up stale files.
COMPUTE is not a standard Delta Lake command for file removal; it is typically associated with general data processing or transformation.
OPTIMIZE is used to compact small files into larger ones to improve query performance but does not remove old, unreferenced files.
CLONE creates a copy of a table at a specific version and is not used for removing old files.
Concept tested: Delta Lake VACUUM command for data retention
Source: https://learn.microsoft.com/en-us/azure/databricks/delta/vacuum
Topics
Community Discussion
No community discussion yet for this question.