Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Databricks Certified Data Analyst Associate Exam - Topic 3 Question 51 Discussion

In which circumstance will there be a substantial difference between the variable's mean and median values?
D) When the variable contains a lot of extreme outliers
A) When the variable is of the categorical type
B) When the variable is of the boolean type
C) When the variable contains no outliers

Databricks Certified Data Analyst Associate Exam - Topic 3 Question 51 Discussion

Actual exam question for Databricks's Databricks Certified Data Analyst Associate exam
Question #: 51
Topic #: 3
[All Databricks Certified Data Analyst Associate Questions]

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

Show Suggested Answer Hide 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 Luz at May 06, 2026, 10:07 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:

0/2000 characters
Submit Cancel
Lindsey
2 hours ago
Wait, are you sure? I thought it was about the distribution shape.
upvoted 0 times
...
Honey
5 days ago
Totally agree, outliers can mess things up big time.
upvoted 0 times
...
Dona
10 days ago
D is the right answer! Extreme outliers really skew the mean.
upvoted 0 times
...
Theola
16 days ago
I wonder if B could be a trick option since boolean variables are just 0s and 1s, but I think outliers are definitely the key here.
upvoted 0 times
...
Antonio
2 months ago
I'm not entirely sure, but I feel like categorical variables wouldn't really have a mean or median, so A seems unlikely.
upvoted 0 times
...
Clarence
2 months ago
I remember practicing a question about means and medians, and it mentioned that outliers really affect the mean more than the median.
upvoted 0 times
...
Jaime
2 months ago
I think the mean and median can differ a lot when there are extreme outliers, so maybe D is the right answer?
upvoted 0 times
...

Save Cancel