Which of the following code blocks accomplishes this task?

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”)

View Answer

Answer: D