Answer-first summary for fast verification
Answer: 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.
The correct answer is B. The `RESTORE` command in Delta Lake is specifically designed to roll back a table to a previous version by specifying the version number, ensuring data integrity and minimal downtime. The `AS OF` clause allows for querying the table as it was at that specific version, providing the analytics team with the ability to generate reports based on historical data. This approach is optimal for maintaining data consistency and supporting audit requirements.
Author: LeetQuiz Editorial Team
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.
No comments yet.