Answer-first summary for fast verification
Answer: 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.
The correct approach is to first use the DESCRIBE HISTORY command to identify the specific version from three months ago. Then, use the SELECT * FROM customer_info VERSION AS OF command to query that specific version and overwrite the current table with this historical data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.