Databricks Exam Databricks Certified Data Analyst Associate Topic 2 Question 42 Discussion

Actual exam question for Databricks's Databricks Certified Data Analyst Associate exam

Question #: 42
Topic #: 2

[All Databricks Certified Data Analyst Associate Questions]

In which circumstance will there be a substantial difference between the variable's mean and median values?

AWhen the variable is of the categorical type

BWhen the variable is of the boolean type

CWhen the variable contains no outliers

DWhen the variable contains a lot of extreme outliers

Show Suggested Answer

Suggested Answer: D

The mean is sensitive to extreme values, often called outliers, which can significantly skew the average away from the true center of the data. The median, however, is a measure of central tendency that is resistant to such outliers because it only considers the middle value(s) when the data is ordered. Therefore, when a variable contains many extreme outliers, there will be a substantial difference between the mean and the median. According to Databricks data analysis materials, this is a fundamental concept when choosing summary statistics for reporting.

by Ardella at Aug 14, 2025, 07:11 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Analyst Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Layla

2 days ago

I'm not entirely sure, but I feel like the mean and median would be close if there are no outliers, which makes me lean away from C.

upvoted 0 times

...

Elenor

8 days ago

I remember we discussed how outliers can really skew the mean, so I think D might be the right choice.

upvoted 0 times

...

Brittani

13 days ago

I feel pretty confident about this question. The key is recognizing that the mean is more influenced by extreme values, while the median is more resistant to outliers. So the circumstances where they would differ substantially are when there are a lot of outliers in the data.

upvoted 0 times

...

Elenore

18 days ago

I'm a bit confused on this one. I know the mean and median behave differently, but I'm not sure I fully understand how the variable type or outliers would affect the relationship between them. I'll have to think it through step-by-step.

upvoted 0 times

...

Cristina

23 days ago

Okay, I've got a strategy for this. The mean is sensitive to outliers, while the median is more robust. So I'll need to consider how the variable type and presence of outliers could impact the difference between the mean and median.

upvoted 0 times

...

Cristy

28 days ago

Hmm, this is a tricky one. I'm not entirely sure about the relationship between the mean, median, and different variable types. I'll need to think through the properties of each option carefully.

upvoted 0 times

...

Bea

1 month ago

This question seems straightforward. I think the key is understanding how the mean and median are affected by the data distribution. I'll focus on identifying the circumstances where the mean and median would differ substantially.

upvoted 0 times

...

Alaine

1 month ago

Definitely option D, when the variable contains a lot of extreme outliers. The median would be less affected by the outliers compared to the mean.

upvoted 0 times

...

Marge

3 months ago

D) When the variable contains a lot of extreme outliers

upvoted 0 times

...