Salesforce ANC-301 Exam - Topic 5 Question 62 Discussion

Actual exam question for Salesforce's ANC-301 exam

Question #: 62
Topic #: 5

A consultant is preparing a dataset to predict customer lifetime value and is collecting data from a questionnaire that asks for demographic information. A very small number of respondents fill in the Income box, but the consultant thinks that it is an informative column even though it only represents 1% of respondents.

What should the consultant do?

AFill in the missing data with an average of all incomes.

BApply the predict missing values transformation in recipe nodes.

CDrop the field as it will be difficult to get future respondents.

Show Suggested Answer

Suggested Answer: B

In CRM Analytics, when dealing with incomplete data, specifically when certain respondents have not filled out fields like income, the Predict Missing Values transformation in a recipe is highly effective. This transformation allows you to predict values for missing fields based on patterns from the existing data. Since the consultant finds this field informative despite having data from only 1% of respondents, applying this transformation can estimate these missing values, which ensures that the dataset remains useful for predictive purposes without discarding important variables. Reference: CRM Analytics Recipes and Predict Missing Values

by Queenie at Nov 21, 2025, 07:21 AM

Limited Time Offer

25%

Off

Get Premium ANC-301 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Ammie

3 days ago

Surprised that only 1% shared income info, that's low!

upvoted 0 times

...

Moon

8 days ago

I think dropping it makes sense, too few responses!

upvoted 0 times

...

Alica

13 days ago

Haha, maybe the respondents are trying to hide their secret wealth! But in all seriousness, B seems like the best choice here.

upvoted 0 times

...

Sharika

18 days ago

I'd go with B. Predicting the missing values is more statistically sound than just using the average. Though I do wonder why the income question is so unpopular...

upvoted 0 times

...

Simona

24 days ago

Hmm, I'm not sure. Option A seems like a quick fix, but B might be more accurate. Either way, that 1% response rate is pretty low.

upvoted 0 times

...

Bernardine

29 days ago

Definitely C. If only 1% of respondents are providing income data, it's not worth keeping that field. Might as well drop it.

upvoted 0 times

...

Brice

1 month ago

I think option B is the way to go. Predicting the missing values is a better approach than just filling in with the average.

upvoted 0 times

...

Lashawn

1 month ago

I recall a practice question where we had to decide on handling missing values, and I think the predictive method was favored over just dropping the column.

upvoted 0 times

...

Joseph

1 month ago

Dropping the income field might seem like a safe option, but I feel like it could still hold some value if we can find a way to estimate the missing data.

upvoted 0 times

...

Teddy

2 months ago

I think using a predictive model to fill in missing values could be a better approach, but I'm not entirely sure how accurate that would be with just 1% of respondents.

upvoted 0 times

...

Mozell

2 months ago

I'm feeling pretty confident about this one. I think option B is the way to go. Predicting the missing values is going to give me a more accurate model than just using the average or dropping the field. I'll make sure to document my approach clearly in my answer.

upvoted 0 times

...

Avery

2 months ago

This is a tricky one. I'm leaning towards option B - using the predict missing values transformation. That seems like the most robust way to handle the missing data, rather than just filling it in or dropping the field entirely. I'll make sure to explain my reasoning on that.

upvoted 0 times

...

Stevie

2 months ago

I remember we discussed how filling in missing data with averages can skew results, especially if the sample size is so small.

upvoted 0 times

...

Salome

2 months ago

Okay, I think I've got a strategy here. The "predict missing values" transformation sounds like the best approach to me. That way I can try to estimate the missing incomes based on the other demographic data, without just using a simple average.

upvoted 0 times

...

Frederica

3 months ago

Filling in with an average could skew results.

upvoted 0 times

...

Carman

3 months ago

I think option A is too simplistic.

upvoted 0 times

...

Emilio

3 months ago

Hmm, I'm not sure about this one. Filling in the missing data with the average seems like it could skew the results, but dropping the field might mean losing out on some valuable information. I'll have to think this through carefully.

upvoted 0 times

...

Jutta

3 months ago

I'm a bit confused on this one. Should I just fill in the missing data with the average income? Or is there a better way to handle the missing values?

upvoted 0 times

Kristal

3 months ago

Dropping the field might lose valuable insights.

upvoted 0 times

...