Exam Certified Data Engineer Professional topic 1 question 181 discussion

Actual exam question from Databricks's Certified Data Engineer Professional

Question #: 181
Topic #: 1

[All Certified Data Engineer Professional Questions]

A Delta Lake table was created with the below query:

Realizing that the original query had a typographical error, the below code was executed:

ALTER TABLE prod.sales_by_stor RENAME TO prod.sales_by_store

Which result will occur after running the second command?

A. The table reference in the metastore is updated.
B. All related files and metadata are dropped and recreated in a single ACID transaction.
C. The table name change is recorded in the Delta transaction log.
D. A new Delta transaction log is created for the renamed table.

Show Suggested Answer

Suggested Answer: A 🗳️

by RandomForest at Jan. 16, 2025, 12:55 p.m.

Comments

Submit Cancel

d3567cc

5 days, 3 hours ago

Selected Answer: A

same quesion listed before with answer A which is corrected one

upvoted 1 times

...

Stalker200

1 month, 4 weeks ago

Selected Answer: A

The Hive Metastore (or Unity Catalog) updates the logical table name. The data and files stay untouched.

upvoted 1 times

...

lakime

3 months, 1 week ago

Selected Answer: C

while the metastore is updated, the key mechanism for tracking changes in Delta Lake is the transaction log.

upvoted 2 times

...