
Ultimate access to all questions.
A Delta Lake table named production.saledata_by_user was initially created with the following query:
CREATE TABLE production.saledata_by_user
USING DELTA
LOCATION "/mnt/production/saledata_by_store"
CREATE TABLE production.saledata_by_user
USING DELTA
LOCATION "/mnt/production/saledata_by_store"
Recognizing a typographical error in the table name, the developer executed the following command:
ALTER TABLE production.saledata_by_user RENAME TO production.saledata_by_store
ALTER TABLE production.saledata_by_user RENAME TO production.saledata_by_store
What is the outcome of running this second command?
A
The table reference in the metastore is updated, and all underlying data files are relocated to a new path matching the table name.
B
The table reference in the metastore is updated, but no data movement or changes to the underlying files occur.
C
The rename operation is recorded as a new version in the Delta transaction log.
D
A new Delta transaction log is initiated in the storage path for the renamed table.
E
The existing data and metadata are discarded and then regenerated within a single ACID transaction.