Exam Certified Associate Developer for Apache Spark topic 1 question 111 discussion

Actual exam question from Databricks's Certified Associate Developer for Apache Spark

Question #: 111
Topic #: 1

[All Certified Associate Developer for Apache Spark Questions]

Which of the following pairs of arguments cannot be used in DataFrame.join() to perform an inner join on two DataFrames, named and aliased with "a" and "b" respectively, to specify two key columns column1 and column2?

A. joinExprs = col(“a.column1”) === col(“b.column1”) and col(“a.column2”) === col(“b.column2”)
B. usingColumns = Seq(col(“column1”), col(“column2”))
C. All of these options can be used to perform an inner join with two key columns.
D. joinExprs = storesDF(“column1”) === employeesDF(“column1”) and storesDF(“column2”) === employeesDF (“column2”)
E. usingColumns = Seq(“column1”, “column2”)

Show Suggested Answer

Suggested Answer: B 🗳️

by Sowwy1 at April 2, 2024, 1:58 p.m.

Comments

Submit Cancel

Alucard069

6 months, 4 weeks ago

Will option D work? I have never seen this way of accessing columns in a dataframe : df("column") , it should be either df.column or col("a.column") [ considering a as an alias of df]

upvoted 2 times

...

Sowwy1

7 months, 3 weeks ago

I think it s B

upvoted 1 times

...

Exam Certified Associate Developer for Apache Spark All Questions

View all questions & answers for the Certified Associate Developer for Apache Spark exam

Exam Certified Associate Developer for Apache Spark topic 1 question 111 discussion

Comments

Alucard069

Sowwy1

Get IT Certification

New Version GCP Professional Cloud Architect Certificate & Helpful Information

The 5 Most In-Demand Project Management Certifications of 2019