Databricks Certified Machine Learning Professional — Question 49

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?

Answer options

• A. VERSION
• B. DESCRIBE
• C. HISTORY
• D. DESCRIBE HISTORY
• E. TIMESTAMP

Correct answer: D

Explanation

The correct answer is 'DESCRIBE HISTORY' because it provides the history of changes made to a Delta table, detailing when specific columns were added or removed. The other options do not offer this specific historical context regarding the schema changes; 'VERSION' and 'TIMESTAMP' do not show the history, while 'DESCRIBE' and 'HISTORY' lack the complete detail necessary for this task.