Answer-first summary for fast verification
Answer: Use the `DESCRIBE HISTORY` command to view the history of table transactions, including details on who made each change, when it was made, and the operation performed.
The correct answer is A: Use the `DESCRIBE HISTORY` command to view the history of table transactions. In Delta Lake, the `DESCRIBE HISTORY` command provides a detailed log of all changes made to a table, including the user who made each change, the timestamp of the change, and the operation performed. This command is specifically designed for auditing and compliance purposes, making it the best choice for reviewing table transaction history. Options B, C, and D refer to commands that do not exist in Delta Lake as described, making them incorrect choices.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
In a scenario where you are working with a large dataset in a Delta Lake table within a Databricks environment, you need to perform incremental data processing. The project requires compliance with data governance policies, necessitating the review of table transaction history to identify who made changes and what operations were performed. Given these requirements, which of the following commands would you use to accurately identify the authors of previous versions of the table and review the history of table transactions? Choose the best option.
A
Use the DESCRIBE HISTORY command to view the history of table transactions, including details on who made each change, when it was made, and the operation performed.
B
Use the SHOW VERSIONS command to list all versions of the table and identify the author of each version, assuming this command exists in Delta Lake.
C
Use the GET PREVIOUS VERSION command to retrieve the previous version of the table and identify the author, assuming this command provides detailed transaction history.
D
Use the AUDIT command to track changes made to the table and identify the author of each change, assuming this command is available in Delta Lake for detailed transaction logging.