CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #97
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #97: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #97. The question stem and answer options stay visible for context.
Question
In order to prevent accidental commits to production data, a senior data engineer has instituted a policy that all development work will reference clones of Delta Lake tables. After testing both deep and shallow clone, development tables are created using shallow clone. A few weeks after initial table creation, the cloned versions of several tables implemented as Type 1 Slowly Changing Dimension (SCD) stop working. The transaction logs for the source tables show that vacuum was run the day before. Why are the cloned tables no longer working?
Options
- AThe data files compacted by vacuum are not tracked by the cloned metadata; running refresh on
- BBecause Type 1 changes overwrite existing records, Delta Lake cannot guarantee data
- CThe metadata created by the clone operation is referencing data files that were purged as invalid
- DRunning vacuum automatically invalidates any shallow clones of a table; deep clone should
- ETables created with SHALLOW CLONE are automatically deleted after their default retention
Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.