Databricks Data Engineer Professional · Free practice question 6 of 12
UNDROP TABLE for managed tables
A data engineer at Wigton Freight accidentally dropped the Unity Catalog managed table ops.gold.route_costs two days ago. How can it be recovered with its data and history?
- A.RESTORE TABLE ops.gold.route_costs TO VERSION AS OF 0
- B.UNDROP TABLE ops.gold.route_costs
- C.Recreate the table and run a full refresh from bronze
- D.Read the table's files from the cloud storage path and run CONVERT TO DELTA
Show answer and explanation
Correct answer: B. UNDROP TABLE ops.gold.route_costs
Why: Unity Catalog keeps dropped managed tables for a recovery period (7 days by default), during which UNDROP TABLE restores them with their data, history and permissions. RESTORE works only on a table that still exists, rebuilding from bronze may not reproduce the same results, and managed table storage paths are not meant to be accessed directly.
More free Databricks Data Engineer Professional questions
- Databricks SQL alerts with notifications
- Partitioning guidance for mid-size tables
- VACUUM retention duration safety check
- SQL warehouse sizing versus scaling
- BROWSE privilege for data discovery
- Workspace-catalog binding isolation
- Bundle generate and deployment bind
- Driver memory and toPandas
- Continuous job trigger for streaming
- Table update triggers for jobs
- Serverless environment dependencies