CERTIFIED-MACHINE-LEARNING-PROFESSIONAL · Question #42
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 bl
Sign in or unlock CERTIFIED-MACHINE-LEARNING-PROFESSIONAL to reveal the answer and full explanation for question #42. The question stem and answer options stay visible for context.
Question
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?
Options
- Aspark.read.format("delta").load(path).drop("star_rating")
- Bspark.read.format("delta").table(path).drop("star_rating")
- CDelta tables cannot be modified
- Dspark.read.table(path).drop("star_rating")
- Espark.sql("SELECT * EXCEPT star_rating FROM path")
Unlock CERTIFIED-MACHINE-LEARNING-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-MACHINE-LEARNING-PROFESSIONAL questions. Unlock CERTIFIED-MACHINE-LEARNING-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.