Answer-first summary for fast verification
Answer: Use the DESCRIBE HISTORY command to view a detailed history of transactions, including who made changes, when they were made, and what changes were made, ensuring data governance and tracking changes.
The DESCRIBE HISTORY command provides a detailed history of transactions on the Delta Lake table, including who made changes, when they were made, and what changes were made. This information is crucial for tracking changes, ensuring data governance, and auditing purposes, as it allows for accountability and understanding of who made specific changes to the data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Explain the process of identifying who has written previous versions of a Delta Lake table. Describe how this information can be used to track changes and ensure data governance.
A
Use the SHOW CREATE TABLE command to view the table creation details and infer who wrote previous versions.
B
Use the DESCRIBE HISTORY command to view a detailed history of transactions, including who made changes, when they were made, and what changes were made, ensuring data governance and tracking changes.
C
Use the SELECT * FROM table_name command to inspect the data and deduce who wrote previous versions.
D
Use the VACUUM command to clean up the table and review who wrote previous versions.
No comments yet.