Confidently Practice Online with Free Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 Exam Cram

Practice your Databricks Certified Associate Developer for Apache Spark 3.0 certification test with free Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 exam cram and take control of your certification preparation. At FreeExamCram, you can practice online for free using real Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 exam dumps, verified questions, and expert-designed free online practice tests. Moreover our Databricks Databricks-Certified-Associate-Developer-for-Apache-Spark-3.0 exam cram backed by our confidence-boosting refund guarantee.

Question 1

Which of the following code blocks returns DataFrame transactionsDf sorted in descending order by column predError, showing missing values last?

Options :

A : transactionsDf.sort(asc_nulls_last("predError"))

B : transactionsDf.orderBy("predError").desc_nulls_last()

C : transactionsDf.sort("predError", ascending=False)

D : transactionsDf.desc_nulls_last("predError")

E : transactionsDf.orderBy("predError").asc_nulls_last()

Answer: C

Question 2

Which of the following code blocks adds a column predErrorSqrt to DataFrame transactionsDf that is the square root of column predError?

Options :

A : transactionsDf.withColumn("predErrorSqrt", sqrt(predError))

B : transactionsDf.select(sqrt(predError))

C : transactionsDf.withColumn("predErrorSqrt", col("predError").sqrt())

D : transactionsDf.withColumn("predErrorSqrt", sqrt(col("predError")))

E : transactionsDf.select(sqrt("predError"))

Answer: D

Question 3

Choose the correct code block to unpersist a table named ‘table’.

Options :

A : spark.catalog.uncacheTable(table)

B : spark.uncacheTable(table)

C : spark.catalog.uncacheTable(“table”)

D : spark.uncacheTable(“table”)

Answer: C

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?

Options :

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

The code block shown below should return a new DataFrame with a new column named “casted” who’s value is the long equivalent of column “a” which is a integer column also this dataframe should contain all the previously existing columns from DataFrame df. Choose the response that correclty fills in the numbered blanks within the code block to complete this task. Code block: df._1_(_2_)

Options :

A :

1. withColumn

2. “casted”

3. cast(a)

B :

1. withColumnRenamed

2. casted

3. col(“a”).cast(“long”)

C :

1. withColumn

2. “casted”

3. cast(col(“a”)

D :

1. withColumnRenamed

2. “casted”

3. col(“a”).cast(“long”)

E :

1. withColumn

2. “casted”

3. col(“a”).cast(“long”)

F :

1. withColumn

2. casted

3. col(a).cast(long)

Answer: A