Question

A data engineer accidentally ran a DELETE statement that removed thousands of rows from a Delta table named sales_transactions 20 minutes ago. No VACUUM has been run since the mistake, and the table retention settings are at their defaults. The engineer needs to restore the table to its exact state before the erroneous DELETE. Which approach will correctly recover the data?

Accepted Answer

Use RESTORE TABLE sales_transactions TO VERSION AS OF <version-before-delete>, identifying the version with DESCRIBE HISTORY.

Answer

Run OPTIMIZE sales_transactions to rebuild the data files and recover the deleted rows automatically.

Answer

Re-run the DELETE statement, which toggles the deleted rows back into the table via ACID rollback.

Answer

Immediately run VACUUM sales_transactions to reclaim the deleted rows from the transaction log.