Exam Certified Machine Learning Professional topic 1 question 16 discussion

Actual exam question from Databricks's Certified Machine Learning Professional

Question #: 16
Topic #: 1

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

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

Show Suggested Answer

Suggested Answer: D 🗳️

by StevenTan at Jan. 4, 2024, 9:47 a.m.

Comments

Submit Cancel

hugodscarvalho

10 months ago

Selected Answer: D

DESCRIBE HISTORY command in SQL provides a history of all changes made to a Delta table, including column additions and deletions. Doc: https://docs.databricks.com/en/sql/language-manual/delta-describe-history.html

upvoted 2 times

...

StevenTan

10 months, 3 weeks ago

Selected Answer: D

D is correct. https://docs.databricks.com/en/sql/language-manual/delta-describe-history.html

upvoted 2 times

...

Exam Certified Machine Learning Professional All Questions

View all questions & answers for the Certified Machine Learning Professional exam

Exam Certified Machine Learning Professional topic 1 question 16 discussion

Comments

hugodscarvalho

StevenTan

Get IT Certification

New Version GCP Professional Cloud Architect Certificate & Helpful Information

The 5 Most In-Demand Project Management Certifications of 2019