Free Microsoft Data Engineering DP-700 Actual Exam Questions - Question 2 Discussion
requirements. What should you include in the recommendation?
It’s A. If the goal is to handle old files without just deleting, copying them somewhere else first makes sense. B and C are more about managing data inside a Delta Lake, so they’d only fit if that’s the format here. D is too final if we need to keep files around somehow. Since the question says “handling” old files but doesn’t confirm deletion, copying with a data pipeline covers archiving or moving without losing data.
If the goal is just to remove old files entirely, D seems straightforward since it deletes them. No extra steps like copying or optimizing needed if cleanup is the main focus. D
C imo, OPTIMIZE helps compact files and improve query performance, which can be part of managing old data efficiently without just deleting it. It’s more about refining storage than outright removal.
B imo, running VACUUM on old files helps clean up obsolete data and reclaim storage without needing to delete everything outright. VACUUM is designed for removing old data files that are no longer needed after updates or deletes, which fits the idea of handling old files technically. Deleting outright (D) might be too aggressive if the system relies on transactional aspects or retention policies. So a notebook running VACUUM could be the better technical approach here for file management within the data platform context.
Yeah, since it’s about handling old files without mentioning archiving, deleting (D) seems the most direct way to meet the technical needs here.
If the goal is just to get rid of old files, D makes sense. But if it’s about managing file storage or cleanup without losing data, maybe A helps more by moving them instead of deleting. Does the question clarify that?
Option A could work too since copying data might help archive or move old files, keeping things tidy without outright deleting. If the goal is to handle old files by moving them elsewhere, not just deleting, then Copy data activity makes sense. Deleting (D) is good if you want to remove files permanently, but if you need to retain them somewhere else, copying fits better.
D, seems like deleting old files fits best for handling them.