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.
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 understanding the evolution of the data, auditing purposes, and troubleshooting issues such as data corruption or unexpected changes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Describe the process of reviewing a history of table transactions in a Delta Lake table. Explain how this information can be used to understand data evolution and troubleshoot issues.
A
Use the SHOW CREATE TABLE command to view the table creation details and infer transaction history.
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.
C
Use the SELECT * FROM table_name command to inspect the data and deduce transaction history.
D
Use the VACUUM command to clean up the table and review the transaction history.