Databricks Certified Associate Developer for Apache Spark — Question 123

Which of the following sets of DataFrame methods will both return a new DataFrame only containing rows that meet a specified logical condition?

Answer options

• A. drop(), where()
• B. filter(), select()
• C. filter(), where()
• D. select(), where()
• E. filter(), drop()

Correct answer: C

Explanation

The methods filter() and where() are both designed to return a DataFrame that contains only the rows meeting a specified condition. The other options include methods like drop() and select(), which do not specifically focus on filtering rows based on logical conditions.