Practice Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Exam Online

Question 1

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

A : df.withColumn(“new_column”, 1)

B : df.withColumn(new_column, lit(1))

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

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

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

Answer: A

Question 2

Which of the following code blocks returns a DataFrame with approximately 1,000 rows from the 10,000-row

DataFrame itemsDf, without any duplicates, returning the same rows even if the code

block is run twice?

A : itemsDf.sampleBy("row", fractions={0: 0.1}, seed=82371)

B : itemsDf.sample(fraction=0.1, seed=87238)

C : itemsDf.sample(fraction=1000, seed=98263)

D : itemsDf.sample(withReplacement=True, fraction=0.1, seed=23536)

E : itemsDf.sample(fraction=0.1)

Answer: B

Question 3

We have an unmanaged table “my_table”

If we run the code block down below

spark.sql(“DROP TABLE IF EXISTS my_table”)

What will happen to data in my_table ?

A : No data will be removed but you will no longer be able to refer to this data by the table name.

B : The data will be dropped also

C : Spark will remove the table and also associated views

D : This is not a valid code block

Answer: A

Question 4

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

A : orderBy()

B : cache()

C : distinct()

D : drop()

E : filter()

F : repartition()

Answer:

Question 5

Given an instance of SparkSession named spark, and the following DataFrame named df:

1. val simpleData = Seq(

2. ("James","Sales","NY",90000,34,10000),

3. ("Michael","Sales","NY",86000,56,20000),

4. ("Robert","Sales","CA",81000,30,23000),

5. ("Maria","Finance","CA",90000,24,23000),

6. ("Raman","Finance","CA",99000,40,24000),

7. ("Scott","Finance","NY",83000,36,19000),

8. ("Jen","Finance","NY",79000,53,15000),

9. ("Jeff","Marketing","CA",80000,25,18000),

10. ("Kumar","Marketing","NY",91000,50,21000)

11. )

val df = spark.createDataFrame(simpleData).toDf("employee_name","department","state","salary","age","bonus")

Choose the right code block which will produce the following result:

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

2. |department|sum(salary)

3.

4. +----------+-----------+

5. Sales |257000

6. Finance |351000

7. Marketing |171000

8.

9. +----------+-----------+

A : df.groupBy("department").agg("salary").show()

B : df.groupBy(department).sum(salary).show()

C : df.groupBy("department").sumAll("salary").show()

D : df.reduce("department").sum("salary").show()

E : df.groupBy("department").sum("salary").show()

Answer: A

Name:	Databricks Certified Associate Developer for Apache Spark 3.0
Exam Code:	Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0
Certification:	Apache Spark Associate Developer
Vendor:	Databricks
Total Questions:	420
Last Updated:	Apr 22, 2024

Databricks Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0