MENU
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?
Suggested Answer: C
Get Premium Databricks Machine Learning Professional Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
31 comments · newest first
IR
Ira
10 months ago
I thought TIMESTAMP could do it, but I guess not!
DO
Doretha
11 months ago
VERSION won't help with that, it's not the right command.
TI
Titus
11 months ago
Wait, can you really track when a column was dropped?
MA
Marget
11 months ago
Definitely, it shows the changes over time.
IL
Iluminada
11 months ago
I think DESCRIBE HISTORY is the way to go!
DE
Desmond
12 months ago
I think DESCRIBE HISTORY is the best option here since it should provide a detailed log of changes, including dropped columns.
UN
Una
12 months ago
I feel like DESCRIBE could give us some information, but it might not show the historical changes we're looking for.
HO
Howard
12 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.
FI
Filiberto
1 year 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.
RE
Rebbecca
1 year 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.
LE
Lettie
1 year 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!
GA
Gail
1 year 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?
KE
Kenneth
1 year 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.
BU
Buddy
1 year 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.
VI
Viki
1 year 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.
FE
Felicia
1 year ago
I'm torn between B) DESCRIBE and D) DESCRIBE HISTORY. Either one could give us the details we need, but I think D) is the safer bet.
TR
Truman
1 year ago
Haha, I bet the Delta table is missing more than just a column. Probably the whole data science team dropped the ball on this one!
TA
Tarra
1 year ago
C) HISTORY
PA
Paris
1 year ago
B) DESCRIBE
RE
Reyes
1 year ago
A) VERSION
SA
Salome
1 year ago
I'm going with E) TIMESTAMP. If we can get the timestamp of when the column was dropped, that should give us the information we need.
DO
Donette
1 year ago
C) HISTORY
NA
Nadine
1 year ago
B) DESCRIBE
AL
Alisha
1 year ago
A) VERSION
MA
Marnie
1 year ago
Hmm, I'm not sure. Maybe C) HISTORY would work too? That could show the changes made to the table over time.
TO
Tom
1 year ago
I agree, let's try using C) HISTORY to see when the column was dropped.
BU
Buddy
1 year ago
I think C) HISTORY is the right choice. It should show the history of changes made to the table.
KA
Kathrine
2 years ago
I'm not sure, but I think D) DESCRIBE HISTORY might also work to accomplish the task.
RE
Rebecka
2 years ago
I think the answer is D) DESCRIBE HISTORY. It sounds like the best way to check the history of the Delta table and see when the column was dropped.
JO
Johnathon
2 years ago
I agree with Wade, using HISTORY command can help determine when the column was dropped.
WA
Wade
2 years ago
I think the answer is C) HISTORY.