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

3 months ago

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

upvoted 0 times

Barney

2 months ago

C) Proper transformations need to be performed at the external source prior to External Data API callout.

upvoted 0 times

...

Rodolfo

2 months ago

B) The field value added in the CSV file was contained within double quotes.

upvoted 0 times

...

Cherry

2 months ago

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

upvoted 0 times

...

Reita

3 months 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

3 months 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

3 months ago

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

upvoted 0 times

Linette

2 months ago

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

upvoted 0 times

...

Galen

2 months ago

C) Proper transformations need to be performed at the external source prior to External Data API callout.

upvoted 0 times

...

Stefanie

2 months ago

B) The field value added in the CSV file was contained within double quotes.

upvoted 0 times

...

Luz

2 months ago

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

upvoted 0 times

...

Georgeanna

3 months 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

Yuki

2 months ago

C: We should make sure to include the JSON metadata file next time we upload data using the External Data API.

upvoted 0 times

...

Jackie

3 months ago

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

upvoted 0 times

...

Nidia

3 months ago

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

upvoted 0 times

...

Danica

4 months ago

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

upvoted 0 times

...

Thomasena

4 months ago

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

upvoted 0 times

...

Lemuel

4 months ago

I think the problem is with option B.

upvoted 0 times

...