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

Q24 Single choice

Which of the following code blocks returns a one-column DataFrame of all values in column supplier of DataFrame itemsDf that do not contain the letter X? In the DataFrame, every value should only be listed once.

Sample of DataFrame itemsDf:

1.+------+--------------------+--------------------+-------------------+

3.+------+--------------------+--------------------+-------------------+

7.+------+--------------------+--------------------+-------------------+

A
itemsDf.filter(col(supplier).not_contains('X')).select(supplier).distinct()
B
itemsDf.select(~col('supplier').contains('X')).distinct()
C
itemsDf.filter(not(col('supplier').contains('X'))).select('supplier').unique()
D
itemsDf.filter(~col('supplier').contains('X')).select('supplier').distinct()
E
itemsDf.filter(!col('supplier').contains('X')).select(col('supplier')).unique()

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