Free Online Databricks Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Practice Test

Prepare Your Databricks Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Exam Questions with Free online Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Practice Test. Get Brilliant Databricks Certified Associate Developer for Apache Spark 3.0 Exam Results with Valid Databricks Certified Associate Developer for Apache Spark 3.0 Exam Dumps.

Page: 1 / 84

Total 420 Questions | Updated On: Jul 14, 2024

Add To Cart

Question 1

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 2

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 3

The code block shown below contains an error. Identify the error.

1. def squared(s):

2. return s * s

4. spark.udf.register("square", squared)

5. spark.range(1, 20).createOrReplaceTempView("test")

6. spark.sql(“select id, squared(id) as id_squared from test”)

A : We need to use function ‘square’ instead of ‘squared’ in the sql command. Proper command should be:spark.sql(“select id, square(id) as id_squared from test”)

B : There is no error in the code.We need to add quotes when using udf in sql. Proper usage should be:spark.sql(“select id, “squared(id)” as id_squared from test”)

C : We are not referring to right database. Proper command should be:spark.sql(“select id, squared(id) as id_squared from temp_test”)

D : There is no column id created in the database.

Answer: A

Question 4

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 5

Which property is used to to allocates jobs to different resource pools to achieve resources scheduling within an application ?

A : Fair Scheduler

B : Dynamic allocation

C : There is no need to set a property since spark is by default capable of resizing

Answer: A

Page: 1 / 84

Total 420 Questions | Updated On: Jul 14, 2024

Add To Cart