Answer-first summary for fast verification
Answer: CDF feature is enabled on the table. The '_change_data' folder is the location where CDF data is stored.
Databricks records change data for UPDATE, DELETE, and MERGE operations in the '_change_data' folder under the table directory. The files in this folder adhere to the table's retention policy, meaning that running the VACUUM command will also delete change data feed data. Reference: [Databricks Documentation](https://docs.databricks.com/delta/delta-change-data-feed.html#change-data-storage).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A junior data engineer observes a folder named '_change_data' in a Delta Lake table directory of SCD Type 1. What is the purpose of this folder?
A
The '_change_data' folder is a metadata directory to track any update to the table definition.
B
The '_change_data' folder is the default directory to track the evolution in schema definition.
C
All SCD Type 1 tables have the '_change_data' folder to track the updates applied on the table’s data.
D
Optimized Writes feature is enabled on the table. The '_change_data' folder is the location where the optimized data is stored.
E
CDF feature is enabled on the table. The '_change_data' folder is the location where CDF data is stored.
No comments yet.