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: Jan 10, 2025

Add To Cart

Question 1

Which of the following code blocks reorders the values inside the arrays in column attributes of DataFrame

itemsDf from last to first one in the alphabet?

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

2.|itemId|attributes |supplier |

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

4.|1 |[blue, winter, cozy] |Sports Company Inc.|

5.|2 |[red, summer, fresh, cooling]|YetiX |

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

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

A : emsDf.withColumn('attributes', sort_array(col('attributes').desc()))

B : emsDf.withColumn('attributes', sort_array(desc('attributes')))

C : emsDf.withColumn('attributes', sort(col('attributes'), asc=False))

D : emsDf.withColumn("attributes", sort_array("attributes", asc=False))

E : emsDf.select(sort_array("attributes"))

Answer: D

Question 2

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 3

There is a global temp view named ‘my_global_view’. If I want to query this view within spark, which command do we need to choose ?

A : ark.read.table("global_temp.my_global_view")

B : ark.read.view("global_temp.my_global_view")

C : ark.read.view("my_global_view")

D : ark.read.table("my_global_view")

Answer: A

Question 4

Which of the following is a viable way to improve Spark's performance when dealing with large amounts of data, given that there is only a single application running on the cluster?

A : crease values for the properties spark.default.parallelism and spark.sql.shuffle.partitions

B : crease values for the properties spark.default.parallelism and spark.sql.partitions

C : crease values for the properties spark.sql.parallelism and spark.sql.partitions

D : crease values for the properties spark.sql.parallelism and spark.sql.shuffle.partitions

E : crease values for the properties spark.dynamicAllocation.maxExecutors, spark.default.parallelism, and spark.sql.shuffle.partitions

Answer: A

Question 5

Which of the following code blocks efficiently converts DataFrame transactionsDf from 12 into 24 partitions?

A : ansactionsDf.repartition(24, boost=True)

B : ansactionsDf.repartition()

C : ansactionsDf.repartition("itemId", 24)

D : ansactionsDf.coalesce(24)

E : ansactionsDf.repartition(24)

Answer: A

Page: 1 / 84

Total 420 Questions | Updated On: Jan 10, 2025

Add To Cart