Salesforce Certified Tableau CRM and Einstein Discovery Consultant — Question 76

Universal Containers (UC) sells mostly to the North American market. A consultant is studying the spending habits of UC's customers where the consultant collects the data with a Region column that is 94% North America, 3% Rest of the World, 3% null.

What is the appropriate action to take?

Answer options

• A. Leave the data as-is, let Discovery deal with nulls.
• B. Replace the nulls with "Rest of the World" since Discovery rejects nulls.
• C. Replace the nulls with North America since they are likely "North America".
• D. Drop the column since there is no valuable information from the column.

Correct answer: C

Explanation

The correct answer is C because the majority of the data (94%) indicates North America, suggesting that the nulls are likely also North America. Option A is incorrect because leaving nulls may cause issues in analysis. Option B is not suitable since replacing nulls with 'Rest of the World' does not reflect the true distribution. Option D is also wrong because the column may still hold valuable insights despite some nulls.