
Ultimate access to all questions.
A junior data engineer accidentally executed a query that deleted all records from the Delta table products. After checking the table's history with DESCRIBE HISTORY products, the latest version is found to be 21. To undo the deletion and restore the table to its state before the accident, which SQL statement should you use?
A
ROLLBACK TABLE products TO VERSION 20
B
RESTORE products TO VERSION AS OF 19
C
ROLLBACK TABLE products TO VERSION 20
D
RESTORE products TO VERSION 19
E
RESTORE TABLE products TO VERSION AS OF 20