
Ultimate access to all questions.
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.