Salesforce ANC-301 Exam - Topic 4 Question 68 Discussion

Actual exam question for Salesforce's ANC-301 exam

Question #: 68
Topic #: 4

A CRM Analytics consultant at Cloud Kicks is trying to upload data using an External Data API and the CSV file with the data was uploaded successfully. Upon analyzing the data using a lens, they find

they are unable to perform any mathematical operations as all the data and fields are treated as dimensions.

What is causing the problem?

AJSON metadata file was not uploaded along with the CSV data file.

BThe field value added in the CSV file was contained within double quotes.

CProper transformations need to be performed at the external source prior to External Data API callout.

Show Suggested Answer

Suggested Answer: A

by Haydee at Apr 05, 2026, 01:45 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Roy

8 days ago

I have a vague memory of this situation, but I can't recall if the JSON file is mandatory or if it's just a best practice.

upvoted 0 times

...

Van

13 days ago

I’m not entirely sure, but I feel like transformations at the source might be necessary. We practiced something similar in class.

upvoted 0 times

...

Alyce

18 days ago

I think I read that if the values in the CSV are in double quotes, it might treat them as strings, which could explain why we can't do math.

upvoted 0 times

...

Stephaine

23 days ago

I remember something about needing a JSON metadata file for the data to be recognized correctly. That could be it.

upvoted 0 times

...