# Certified-Associate-Developer-for-Apache-Spark — Question 426

**Type:** multiple_choice
**Topics:** topic_1

## 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(“divisionDistinct”))

## Correct Answer

_See scenario._

## Explanation

Selected Answer: E
can not get exact distinct using apox function

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/databricks/Certified-Associate-Developer-for-Apache-Spark/426  
Practice (tracked): https://hiexam.net/study/Certified-Associate-Developer-for-Apache-Spark/practice