Databricks Machine Learning Professional Exam - Topic 6 Question 28 Discussion

Actual exam question for Databricks's Databricks Machine Learning Professional exam

Question #: 28
Topic #: 6

[All Databricks Machine Learning Professional Questions]

After a data scientist noticed that a column was missing from a production feature set stored as a Delta table, the machine learning engineering team has been tasked with determining when the column was dropped from the feature set.

Which of the following SQL commands can be used to accomplish this task?

AVERSION

BDESCRIBE

CHISTORY

DDESCRIBE HISTORY

ETIMESTAMP

Show Suggested Answer

Suggested Answer: C

by Cecily at Sep 17, 2024, 11:47 AM

Limited Time Offer

25%

Off

Get Premium Databricks Machine Learning Professional Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Ira

6 months ago

I thought TIMESTAMP could do it, but I guess not!

upvoted 0 times

...

Doretha

6 months ago

VERSION won't help with that, it's not the right command.

upvoted 0 times

...

Titus

6 months ago

Wait, can you really track when a column was dropped?

upvoted 0 times

...

Marget

7 months ago

Definitely, it shows the changes over time.

upvoted 0 times

...

Iluminada

7 months ago

I think DESCRIBE HISTORY is the way to go!

upvoted 0 times

...

Desmond

7 months ago

I think DESCRIBE HISTORY is the best option here since it should provide a detailed log of changes, including dropped columns.

upvoted 0 times

...

Una

7 months ago

I feel like DESCRIBE could give us some information, but it might not show the historical changes we're looking for.

upvoted 0 times

...

Howard

7 months ago

I remember practicing with the HISTORY command in a similar question, but I can't recall if it specifically shows when columns were dropped.

upvoted 0 times

...

Filiberto

8 months ago

I think we might need to use the DESCRIBE HISTORY command to see the changes made to the Delta table, but I'm not entirely sure.

upvoted 0 times

...

Rebbecca

8 months ago

Ugh, I'm really not sure about this one. There are a lot of SQL commands to choose from, and I'm not confident I know which one will give me the information I need. Guess I'll just have to make an educated guess and hope for the best.

upvoted 0 times

...

Lettie

8 months ago

I've got this! The VERSION command will show me the different versions of the Delta table, and then I can use DESCRIBE HISTORY on each version to pinpoint when the column disappeared. Easy peasy!

upvoted 0 times

...

Gail

8 months ago

I'm a bit confused on this one. I know the DESCRIBE command can give me information about the table structure, but I'm not sure if that will tell me when a column was dropped. Maybe the HISTORY command would be better?

upvoted 0 times

...

Kenneth

8 months ago

Okay, let's see here. I'm pretty sure the DESCRIBE HISTORY command is the way to go - it should show the changes made to the table over time, including when columns were added or removed.

upvoted 0 times

...

Buddy

8 months ago

Hmm, this seems like a tricky one. I'll need to think through the different SQL commands carefully to determine which one is best for finding when the column was dropped.

upvoted 0 times

...

Viki

8 months ago

Hmm, this one has me a bit stumped. I'm not totally sure which stakeholder would have the best handle on the technical constraints. The project manager might have a good overview, but the suppliers would probably have the most detailed technical knowledge. I'll have to think this through carefully.

upvoted 0 times

...