Databricks Certified Data Engineer Professional Exam - Topic 3 Question 30 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Professional exam

Question #: 30
Topic #: 3

[All Databricks 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?

AThe table reference in the metastore is updated and no data is changed.

BThe table name change is recorded in the Delta transaction log.

CAll related files and metadata are dropped and recreated in a single ACID transaction.

DThe table reference in the metastore is updated and all data files are moved.

EA new Delta transaction log Is created for the renamed table.

Show Suggested Answer

Suggested Answer: A

The Databricks CLI provides a way to automate interactions with Databricks services. When dealing with pipelines, you can use the databricks pipelines get --pipeline-id command to capture the settings of an existing pipeline in JSON format. This JSON can then be modified by removing the pipeline_id to prevent conflicts and renaming the pipeline to create a new pipeline. The modified JSON file can then be used with the databricks pipelines create command to create a new pipeline with those settings.

Databricks Documentation on CLI for Pipelines: Databricks CLI - Pipelines

by Malinda at Feb 10, 2025, 02:26 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Engineer Professional Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Judy

6 months ago

New Delta transaction log is created for the renamed table, right?

upvoted 0 times

...

Eric

6 months ago

Wait, does it really not move any data files? That seems odd.

upvoted 0 times

...

Phuong

6 months ago

I think the transaction log gets updated too.

upvoted 0 times

...

Jodi

7 months ago

Totally agree, just a name change!

upvoted 0 times

...

Eladia

7 months ago

The table reference in the metastore is updated, no data changes.

upvoted 0 times

...

Hoa

7 months ago

I feel like I read that a new transaction log is created for changes like this, but I'm not completely sure. E could be a possibility too.

upvoted 0 times

...

Martina

7 months ago

I practiced a similar question, and I recall that renaming a table doesn't drop or recreate files. So I doubt C is correct.

upvoted 0 times

...

Murray

7 months ago

I'm a bit unsure, but I think the transaction log gets updated when you rename a table. So maybe B is the right answer?

upvoted 0 times

...

Desmond

8 months ago

I remember that renaming a table in Delta Lake doesn't actually move the data files, just updates the reference in the metastore. So I think A might be correct.

upvoted 0 times

...

Remedios

8 months ago

This seems like a straightforward Delta Lake table rename operation, so I'm feeling pretty confident about this one. I know that Delta Lake maintains a transaction log and updates the table metadata, so I think option B is the correct answer here.

upvoted 0 times

...

Val

8 months ago

I'm a little confused by this question. The options seem to be describing different behaviors, and I'm not sure which one is correct. I'll need to review my Delta Lake knowledge to make sure I understand the implications of renaming a table in this system. Hopefully, I can narrow it down and make an educated guess.

upvoted 0 times

...

Carmen

8 months ago

Okay, I think I've got this. Based on my knowledge of Delta Lake, the table reference in the metastore should be updated, but the data files themselves should just be moved rather than recreated. So I'm going to go with option D as the correct answer.

upvoted 0 times

...

Daniel

8 months ago

Hmm, I'm a bit unsure about this one. The question is asking about the specific result of running the ALTER TABLE command, and I'm not entirely confident I know all the details of how Delta Lake handles table renames. I'll need to think this through carefully.

upvoted 0 times

...

Venita

8 months ago

This looks like a straightforward Delta Lake table rename operation, so I think I can handle this. I'll carefully read through the options and try to apply my understanding of how Delta Lake manages table metadata and data.

upvoted 0 times

...

Hershel

1 year ago

I'm going with B as well. Seems like the cleanest solution that preserves the data and maintains the ACID properties of Delta Lake. Wouldn't want to accidentally drop and recreate the table, that would be a disaster!

upvoted 0 times

...

Alease

1 year ago

Option B makes the most sense to me. Updating the metadata in the transaction log is the most efficient way to handle a table rename without disrupting the data. I'm confident this is the right answer.

upvoted 0 times

Trina

11 months ago

Yes, updating the table name in the Delta transaction log makes the most sense.

upvoted 0 times

...

Alease

11 months ago

Option B is definitely the most efficient way to update the table name without affecting the data.

upvoted 0 times

...

Roselle

11 months ago

I think option B is the best solution for handling a table rename.

upvoted 0 times

...

Ruthann

12 months ago

I agree with you, option B seems like the correct choice.

upvoted 0 times

...

Avery

1 year ago

Haha, I bet the person who wrote this question had a typo in their original code and had to use the ALTER TABLE command to fix it. Gotta love it when exam questions are relatable!

upvoted 0 times

Berry

11 months ago

C) All related files and metadata are dropped and recreated in a single ACID transaction.

upvoted 0 times

...

Nakisha

11 months ago

B) The table name change is recorded in the Delta transaction log.

upvoted 0 times

...

Lucy

12 months ago

A) The table reference in the metastore is updated and no data is changed.

upvoted 0 times

...

Fausto

1 year ago

I think the answer is D. The table reference in the metastore is updated, and all data files are moved to the new location. Seems logical, but let me double-check the documentation.

upvoted 0 times

Janey

11 months ago

Let me verify that, but I'm pretty sure it's B. The table name change is recorded in the Delta transaction log. That's how it usually works.

upvoted 0 times

...

Otis

12 months ago

I believe it's actually C. All related files and metadata are dropped and recreated in a single ACID transaction. That's what I remember from my experience.

upvoted 0 times

...

Leigha

1 year ago

I think the answer is D. The table reference in the metastore is updated, and all data files are moved to the new location. Seems logical, but let me double-check the documentation.

upvoted 0 times

...

Monte

1 year ago

The correct answer is B. The table name change is recorded in the Delta transaction log. This ensures the table metadata is updated without any data loss or recreation of the underlying files.

upvoted 0 times