Free DATABRICKS-MACHINE-LEARNING-PROFESSIONAL Web TestEngine Demo

Q7 Single choice

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

DATABRICKS-MACHINE-LEARNING-PROFESSIONAL Web TestEngine demo