
Ultimate access to all questions.
In the context of managing a data pipeline with Delta Lake on Azure Databricks, you encounter a scenario where you need to roll back a Delta Lake table to a previous version due to an erroneous data load. Additionally, you need to ensure that your analytics team can query the table as it was at that specific version for their reports. Considering the requirements for data integrity, minimal downtime, and the ability to audit changes, which of the following approaches is the BEST to achieve this? Choose the correct option from the four provided.
A
Execute the ROLLBACK command with the version number to revert the table, and use the AS OF clause in your queries to access the specific version.
B
Use the RESTORE command specifying the version number to roll back the table, and utilize the AS OF clause to query the table at that version.
C
Apply the REVERT command along with the version number to undo changes to the table, and employ the AS OF clause for querying the specific version.
D
Implement the UNDO command with the version number to return the table to its previous state, and use the AS OF clause to query the desired version.