
Ultimate access to all questions.
In managing a Delta Lake table within Azure Databricks, you've noticed that the table has accumulated a significant number of deleted files over time, leading to unnecessary storage costs and potential performance degradation. Your team is considering the use of the VACUUM command to address this issue. Given the scenario, which of the following best describes the primary purpose of the VACUUM command and its impact on the table's maintenance? Choose the best option from the four provided.
A
The VACUUM command optimizes query performance by reorganizing the data layout within the table.
B
The VACUUM command updates the table's metadata to ensure it accurately reflects all recent data modifications.
C
The VACUUM command merges small files into larger ones to reduce the total file count, thereby improving read efficiency.
D
The VACUUM command reclaims storage space by permanently deleting files that have been marked as deleted, thus reducing storage costs and maintaining table efficiency.