Free DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Web TestEngine Demo

Q81 Single choice

The code block shown below contains an error. The code block is intended to return a DataFrame containing all columns from DataFrame storesDF except for column sqft and column customerSatisfaction. Identify the error.

Code block:
storesDF.drop(sqft, customerSatisfaction)

A
The drop() operation only works if one column name is called at a time - there should be two calls in succession like storesDF.drop("sqft").drop("customerSatisfaction").
B
The drop() operation only works if column names are wrapped inside the col() function like storesDF.drop(col(sqft), col(customerSatisfaction)).
C
There is no drop() operation for storesDF.
D
The sqft and customerSatisfaction column names should be quoted like "sqft" and "customerSatisfaction".
E
The sqft and customerSatisfaction column names should be subset from the DataFrame storesDF like storesDF."sqft" and storesDF."customerSatisfaction".

DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Web TestEngine demo