Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
After creating a Delta Lake table with the following query that contains a typographical error:
CREATE TABLE prod.sales_by_stor
USING DELTA
LOCATION "/mnt/prod/sales_by_store"
The following command was executed to correct the table name:
ALTER TABLE prod.sales_by_stor RENAME TO prod.sales_by_store
What will be the outcome of executing the second command?
Explanation:
The ALTER TABLE ... RENAME TO command in Delta Lake updates the table name in the metastore without altering the underlying data files or their location. This operation does not involve moving data files or creating a new Delta transaction log for the renamed table. It simply changes the table's name in the catalog, making option A the correct answer as it accurately describes the outcome of the rename operation.