1. Home
  2. Discussions
  3. Databricks
  4. Databricks Certification
  5. Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Discussions
  6. Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Exam Topic 4 Question 37 Discussion

Databricks Certified Associate Developer for Apache Spark 3.0 Exam Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Question # 37 Topic 4 Discussion

 Databricks Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Databricks Certified Associate Developer for Apache Spark 3.0 Exam Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Question # 37 Topic 4 Discussion

Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Exam Topic 4 Question 37 Discussion:
Question #: 37
Topic #: 4

Which of the following code blocks returns a DataFrame with a single column in which all items in column attributes of DataFrame itemsDf are listed that contain the letter i?

Sample of DataFrame itemsDf:

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

2.|itemId|itemName |attributes |supplier |

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

4.|1 |Thick Coat for Walking in the Snow|[blue, winter, cozy] |Sports Company Inc.|

5.|2 |Elegant Outdoors Summer Dress |[red, summer, fresh, cooling]|YetiX |

6.|3 |Outdoors Backpack |[green, summer, travel] |Sports Company Inc.|

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

itemsDf.select(explode("attributes").alias("attributes_exploded")).filter(attributes_exploded.contains("i"))

B.

itemsDf.explode(attributes).alias("attributes_exploded").filter(col("attributes_exploded").contains("i"))

C.

itemsDf.select(explode("attributes")).filter("attributes_exploded".contains("i"))

D.

itemsDf.select(explode("attributes").alias("attributes_exploded")).filter(col("attributes_exploded").contains("i"))

E.

itemsDf.select(col("attributes").explode().alias("attributes_exploded")).filter(col("attributes_exploded").contains("i"))

Get Premium Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Questions
Actual exam question for Databricks Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 exam by Zyra76885 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next