nerdexam
DatabricksDatabricks

DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK · Question #72

DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Question #72: Real Exam Question with Answer & Explanation

Sign in or unlock DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK to reveal the answer and full explanation for question #72. The question stem and answer options stay visible for context.

Performing Aggregations and Transformations with Spark DataFrames

Question

The code block shown below contains an error. The code block is intended to return the exact number of distinct values in column division in DataFrame storesDF. Identify the error. Code block: storesDF.agg(approx_count_distinct(col("division")).alias("divisionDist inct"))

Options

  • AThe approx_count_distinct() operation needs a second argument to set the rsd parameter to
  • BThere is no alias() operation for the approx_count_distinct() operation's output.
  • CThere is no way to return an exact distinct number in Spark because the data Is distributed across
  • DThe approx_count_distinct()operation is not a standalone function - it should be used as a method
  • EThe approx_count_distinct() operation cannot determine an exact number of distinct values in a

Unlock DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK to see the answer

You've previewed enough free DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK questions. Unlock DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Spark Functions#Aggregation#approx_count_distinct#Function Parameters
Full DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK PracticeBrowse All DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Questions