nerdexam
Microsoft

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.

Monitor and optimize an analytics solution

Question

You need to recommend a solution for handling old files. The solution must meet the technical requirements. What should you include in the recommendation?

Exhibit

DP-700 question #94 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)
  • A
    4% (2)
  • B
    13% (7)
  • C
    78% (43)
  • D
    5% (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.

Aa data pipeline that includes a Copy data activity

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.

Ba data pipeline that includes a Delete data activity

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.

Ca notebook that runs the VACUUM commandCorrect

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.

Da notebook that runs the OPTIMIZE command

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

#Delta Lake#VACUUM command#Data Maintenance#Storage Optimization

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice