Salesforce Exam ANC-301 Topic 1 Question 43 Discussion

Actual exam question for Salesforce's ANC-301 exam

Question #: 43
Topic #: 1

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 Elenore at Sep 15, 2024, 10:04 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Linwood

16 days ago

Ah, the old 'all dimensions, no math' problem. Sounds like someone's got a case of the dimensional blues.

upvoted 0 times

...

Reita

17 days ago

Wait, you mean I can't just throw a bunch of data at the API and expect it to magically work? What is this, Hogwarts?

upvoted 0 times

...

Kanisha

18 days ago

Transformations at the external source, eh? Sounds like a classic case of 'garbage in, garbage out'. Gotta do the dirty work before calling the API.

upvoted 0 times

...

Armanda

23 days ago

Haha, double quotes in the CSV? Rookie mistake. That's definitely causing the problem. Gotta clean that up before uploading.

upvoted 0 times

...

Georgeanna

26 days ago

Oh man, this is a tough one. The JSON metadata file is definitely the issue here. Without it, the API has no idea how to treat the data properly.

upvoted 0 times

Jackie

7 days ago

B: That makes sense, without the metadata file, the API doesn't know how to handle the data correctly.

upvoted 0 times

...

Nidia

9 days ago

A: The JSON metadata file was not uploaded along with the CSV data file.

upvoted 0 times

...

Danica

1 months ago

I believe option C is the correct answer, transformations should be done before calling the External Data API.

upvoted 0 times

...

Thomasena

1 months ago

I agree with Lemuel, the double quotes might be causing the issue.

upvoted 0 times

...

Lemuel

2 months ago

I think the problem is with option B.

upvoted 0 times

...