Exam Certified Machine Learning Professional topic 1 question 7 discussion

Actual exam question from Databricks's Certified Machine Learning Professional

Question #: 7
Topic #: 1

[All Certified Machine Learning Professional Questions]

A data scientist wants to remove the star_rating column from the Delta table at the location path. To do this, they need to load in data and drop the star_rating column.
Which of the following code blocks accomplishes this task?

A. spark.read.format(“delta”).load(path).drop(“star_rating”)
B. spark.read.format(“delta”).table(path).drop(“star_rating”)
C. Delta tables cannot be modified
D. spark.read.table(path).drop(“star_rating”)
E. spark.sql(“SELECT * EXCEPT star_rating FROM path”)

Show Suggested Answer

Suggested Answer: A 🗳️

by BokNinja at Dec. 19, 2023, 5:34 a.m.

Comments

Submit Cancel

BokNinja

Highly Voted 1 year, 4 months ago

A. spark.read.format(“delta”).load(path).drop(“star_rating”)

upvoted 7 times

...

sindhu_gowda

Most Recent 10 months, 3 weeks ago

Selected Answer: A

A is correct

upvoted 1 times

...

Alishahab70

1 year, 2 months ago

A is correct, if it was table_name instead of table_path then D would be correct

upvoted 2 times

...

spaceexplorer

1 year, 3 months ago

Selected Answer: D

D is correct:

upvoted 1 times

...

hugodscarvalho

1 year, 3 months ago

Selected Answer: A

This code reads the Delta table located at path, loads it into a DataFrame, and then drops the "star_rating" column from the DataFrame.

upvoted 3 times

...

Exam Certified Machine Learning Professional All Questions

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