Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Exam Marketing Cloud Intelligence Topic 1 Question 6 Discussion

Actual exam question for Salesforce's Marketing Cloud Intelligence exam
Question #: 6
Topic #: 1
[All Marketing Cloud Intelligence Questions]

An implementation engineer is requested to extract the first three-letter segment of the Campaign Name values.

For example:

Campaign Name: AFD@Mulop-1290

Desired outcome: AFD

Other examples:

Which formula will return the desired values?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

Jesusita
5 months ago
I'm feeling a bit like a detective trying to crack this case. Option B looks promising, but I might just go with option A to play it safe. After all, the early bird catches the worm, right?
upvoted 0 times
...
Rolland
5 months ago
Ah, the age-old battle between LEFT() and EXTRACT(). I'd say option A is the way to go here. Gotta love those marketing campaigns with their cryptic names!
upvoted 0 times
...
Aaron
5 months ago
This question is a real brain-teaser! I'm going to go with option E. The LEFT() function combined with the EXTRACT() should do the trick.
upvoted 0 times
...
Norah
6 months ago
Hmm, I'm not sure about this one. The campaign name format looks a bit tricky, but I'm leaning towards option D. Let's see what the others think.
upvoted 0 times
Tijuana
5 months ago
I agree, option D seems like the most logical choice for extracting the desired values.
upvoted 0 times
...
Loren
5 months ago
I think option D looks like the correct formula to extract the first three-letter segment.
upvoted 0 times
...
...
Wade
6 months ago
I think the correct answer is option A. The LEFT() function should extract the first three characters from the campaign name, and EXTRACT() can be used to get the part before the first comma.
upvoted 0 times
Glennis
5 months ago
I think you're right, option A should do the trick.
upvoted 0 times
...
Glennis
5 months ago
I agree, option A seems to be the correct choice.
upvoted 0 times
...
...
Katlyn
7 months ago
I think Robin has a point. Extracting first, then using LEFT to get the first three letters makes sense.
upvoted 0 times
...
Craig
7 months ago
Hmm, but E) LEFT(EXTRACT(csv[campaign_name'}/---',1),3) also returns three letters, exactly what we need.
upvoted 0 times
...
Dulce
7 months ago
I agree with Chris, nested EXTRACT sounds logical. The campaign name structure fits it well.
upvoted 0 times
...
Estrella
7 months ago
Not sure about that, I feel EXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0) is a better option.
upvoted 0 times
...
In
7 months ago
Yeah, I think LEFT(EXTRACT(csy['campaign_name]],~',0),3) might be the right choice.
upvoted 0 times
...
Kenneth
7 months ago
The question seems tricky, extracting segments like that can be complex.
upvoted 0 times
...
Lourdes
8 months ago
I agree with Thomasena, option D makes sense.
upvoted 0 times
...
Thomasena
8 months ago
I'm leaning towards option D.
upvoted 0 times
...
Linette
8 months ago
No, I believe it's option B.
upvoted 0 times
...
Marvel
8 months ago
I think the formula to extract the first three-letter segment is option A.
upvoted 0 times
...

Save Cancel