Explanation:
The correct method to restore the table to its previous state before the deletion is to use the RESTORE TABLE command with the TO VERSION as of clause, specifying the version number before the deletion occurred. This command reverts the table to the specified version, effectively undoing the deletion. The syntax and usage are documented in Databricks SQL's RESTORE command documentation, which supports time travel features using either a timestamp or a version number.
Ultimate access to all questions.
You have accidentally deleted records from a table called 'transactions'. The table's version was 3 before the deletion and 4 after. What is the easiest method to restore the deleted records or revert the table to its previous state?
A
RESTORE TABLE transactions FROM VERSION as of 4
B
MINUS
C
RESTORE TABLE transactions TO VERSION as of 3
D
INSERT INTO OVERWRITE transactions SELECT * FROM transactions VERSION AS OF 3
E
SELECT * FROM transactions INSERT INTO OVERWRITE transactions SELECT * FROM transactions VERSION AS OF 4
F
INTERSECT
No comments yet.