You are tasked with rolling back a Delta Lake table named 'customer_info' to a specific version from three months ago. Describe the steps you would take to achieve this using Databricks SQL or PySpark._

Simulated

Use the RESTORE TABLE command specifying the desired version.

21.8%

Manually copy the data from the desired version and overwrite the current table.

0.7%

Use the DESCRIBE HISTORY command to find the version, then use the SELECT * FROM customer_info VERSION AS OF command to query the specific version and overwrite the current table.*_

77.0%

Delete the current table and recreate it from the backup of the desired version.

0.5%

Databricks Certified Data Engineer - Associate

Get started today

Comments

You are tasked with rolling back a Delta Lake table named 'customer_info' to a specific version from three months ago. Describe the steps you would take to achieve this using Databricks SQL or PySpark._