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?

Real Exam

RESTORE TABLE transactions FROM VERSION as of 4

5.7%

MINUS

0.0%

RESTORE TABLE transactions TO VERSION as of 3

83.6%

INSERT INTO OVERWRITE transactions SELECT * FROM transactions VERSION AS OF 3*

7.8%

SELECT * FROM transactions INSERT INTO OVERWRITE transactions SELECT * FROM transactions VERSION AS OF 4

2.9%

INTERSECT

Databricks Certified Data Engineer - Associate