exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam

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 Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Stalker200
1 week, 2 days 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
1 month, 3 weeks ago
Selected Answer: C
while the metastore is updated, the key mechanism for tracking changes in Delta Lake is the transaction log.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago