Free Databricks Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Exam Questions

Become Databricks Certified with updated Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 exam questions and correct answers

Page: 1 / 84

Total 420 Questions | Updated On: Feb 19, 2025

Add To Cart

Question 1

If we want to create a constant string 1 as a new column ‘new_column’ in the dataframe df, which code block should we select ?

A : .withColumn(new_column, lit(1))

B : .withColumn(“new_column”, 1)

C : .withColumn(“new_column”, lit(1))

D : .withColumnRenamed('new_column', lit(1))

E : .withColumn(”new_column”, lit(“1”))

Answer: A

Question 2

Which of the following is correct for the cluster manager ?

A : ecutes code assigned to it.

B : eps track of the resources available.

C : It is interchangeable with job.

D : ports the state of the computation back to the driver.

E : l of the answers are correct.

Answer: B

Question 3

When the property spark.sql.optimizer.dynamicPartitionPruning.enabled is set to true, what optimization happens in spark ?

A : allows you to dynamically switch join strategies.

B : ark dynamically handles skew in sort-merge join by splitting (and replicating if needed) skewed partitions with this property enabled.

C : u to read only as much data as you need.

D : allows you to dynamically select physical plans based on cost.

Answer: C

Question 4

Which of the following 3 DataFrame operations are classified as a wide transformation ? Choose 3 answers:

A : derBy()

B : op()

C : partition()

D : tinct()

E : lter()

F : che()

Answer: A,C,D

Question 5

Which of the following code blocks reads all CSV files in directory filePath into a single DataFrame, with

column names defined in the CSV file headers?

Content of directory filePath:

1._SUCCESS

2._committed_2754546451699747124

3._started_2754546451699747124

4.part-00000-tid-2754546451699747124-10eb85bf-8d91-4dd0-b60b-2f3c02eeecaa-298-1-c000.csv.gz

5.part-00001-tid-2754546451699747124-10eb85bf-8d91-4dd0-b60b-2f3c02eeecaa-299-1-c000.csv.gz

6.part-00002-tid-2754546451699747124-10eb85bf-8d91-4dd0-b60b-2f3c02eeecaa-300-1-c000.csv.gz

7.part-00003-tid-2754546451699747124-10eb85bf-8d91-4dd0-b60b-2f3c02eeecaa-301-1-c000.csv.gz

spark.option("header",True).csv(filePath)

A : ark.read.format("csv").option("header",True).option("compression","zip").load(filePath)

B : ark.read().option("header",True).load(filePath)

C : ark.read.format("csv").option("header",True).load(filePath)

D : ark.read.load(filePath)

Answer: C

Page: 1 / 84

Total 420 Questions | Updated On: Feb 19, 2025

Add To Cart