DP-700 · Question #94
You need to recommend a solution for handling old files. The solution must meet the technical requirements. What should you include in the recommendation?
The correct answer is C. a notebook that runs the VACUUM command. The solution for handling old files in a Delta table should involve running the VACUUM command to remove unreferenced data files.
Question
Exhibit
Options
- Aa data pipeline that includes a Copy data activity
- Ba data pipeline that includes a Delete data activity
- Ca notebook that runs the VACUUM command
- Da notebook that runs the OPTIMIZE command
How the community answered
(55 responses)- A4% (2)
- B13% (7)
- C78% (43)
- D5% (3)
Why each option
The solution for handling old files in a Delta table should involve running the VACUUM command to remove unreferenced data files.
A Copy data activity moves or copies data, which does not address the specific need to remove old, unreferenced file versions within a Delta table.
A Delete data activity removes files or records, but VACUUM is specifically designed for cleaning up historical versions of files in Delta Lake tables, which is more targeted for "old files" in this context.
VACUUM is a Delta Lake command used to remove data files that are no longer part of the latest version of a Delta table and are older than the retention threshold, effectively cleaning up old, unreferenced files and reclaiming storage. This directly addresses the requirement of handling old files to meet technical requirements, likely related to storage management or compliance.
The OPTIMIZE command is used to compact small files into larger ones to improve query performance on a Delta table, not to remove old, unreferenced files.
Concept tested: Delta Lake table maintenance - VACUUM command
Source: https://learn.microsoft.com/en-us/fabric/data-engineering/delta-lake-overview#delta-lake-maintenance-commands
Topics
Community Discussion
No community discussion yet for this question.
