Databricks Certified Associate Developer for Apache Spark — Question 23

Which of the following code blocks returns a DataFrame containing only the rows from DataFrame storesDF where the value in column sqft is less than or equal to 25,000 OR the value in column customerSatisfaction is greater than or equal to 30?

Answer options

• A. storesDF.filter(col("sqft") <= 25000 | col("customerSatisfaction") >= 30)
• B. storesDF.filter(col("sqft") <= 25000 or col("customerSatisfaction") >= 30)
• C. storesDF.filter(sqft <= 25000 or customerSatisfaction >= 30)
• D. storesDF.filter(col(sqft) <= 25000 | col(customerSatisfaction) >= 30)
• E. storesDF.filter((col("sqft") <= 25000) | (col("customerSatisfaction") >= 30))

Correct answer: E

Explanation

The correct answer is E because it correctly uses the filter method with proper syntax and logical operators to check both conditions. Option A uses the correct syntax but is not the most explicit, while B and C incorrectly use 'or' instead of '|', and D has a syntax error with col() usage.