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

Salesforce ANC-301 Exam - Topic 4 Question 68 Discussion

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 findthey are unable to perform any mathematical operations as all the data and fields are treated as dimensions.What is causing the problem?
A) JSON metadata file was not uploaded along with the CSV data file.
B) The field value added in the CSV file was contained within double quotes.
C) Proper transformations need to be performed at the external source prior to External Data API callout.

Salesforce ANC-301 Exam - Topic 4 Question 68 Discussion

Actual exam question for Salesforce's ANC-301 exam
Question #: 68
Topic #: 4
[All ANC-301 Questions]

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Pearlie
1 month ago
C makes sense too. Transformations are key before uploading.
upvoted 0 times
...
Wilburn
2 months ago
I lean towards B. Double quotes can mess up field recognition.
upvoted 0 times
...
Janna
2 months ago
I think it's A. Missing the JSON file is crucial for data types.
upvoted 0 times
...
Kristel
2 months ago
Not so sure about C, seems like a stretch to blame the external source.
upvoted 0 times
...
Dean
2 months ago
Definitely A, without the JSON, the system can't interpret the data correctly.
upvoted 0 times
...
Ligia
2 months ago
Wait, are you saying the data can't be calculated at all? That's surprising!
upvoted 0 times
...
Claribel
4 months ago
I think B could be the culprit too, double quotes can mess things up.
upvoted 0 times
...
Lashon
4 months ago
Sounds like a metadata issue, A seems right.
upvoted 0 times
...
Roy
5 months 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
5 months 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
5 months 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
5 months ago
I remember something about needing a JSON metadata file for the data to be recognized correctly. That could be it.
upvoted 0 times
...

Save Cancel