Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
A
Use the RESTORE TABLE command specifying the desired version.
B
Manually copy the data from the desired version and overwrite the current table.
C
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.
D
Delete the current table and recreate it from the backup of the desired version.
