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

by Cornell at Apr 25, 2024, 09:46 PM

Limited Time Offer

25%

Off

Get Premium Marketing Cloud Intelligence Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Jesusita
11 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
11 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
11 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
11 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
10 months ago
I agree, option D seems like the most logical choice for extracting the desired values.
upvoted 0 times
...
Loren
11 months ago
I think option D looks like the correct formula to extract the first three-letter segment.
upvoted 0 times
...
...
Wade
11 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
11 months ago
I think you're right, option A should do the trick.
upvoted 0 times
...
Glennis
11 months ago
I agree, option A seems to be the correct choice.
upvoted 0 times
...
...
Katlyn
1 years ago
I think Robin has a point. Extracting first, then using LEFT to get the first three letters makes sense.
upvoted 0 times
...
Craig
1 years ago
Hmm, but E) LEFT(EXTRACT(csv[campaign_name'}/---',1),3) also returns three letters, exactly what we need.
upvoted 0 times
...
Dulce
1 years ago
I agree with Chris, nested EXTRACT sounds logical. The campaign name structure fits it well.
upvoted 0 times
...
Estrella
1 years ago
Not sure about that, I feel EXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0) is a better option.
upvoted 0 times
...
In
1 years ago
Yeah, I think LEFT(EXTRACT(csy['campaign_name]],~',0),3) might be the right choice.
upvoted 0 times
...
Kenneth
1 years ago
The question seems tricky, extracting segments like that can be complex.
upvoted 0 times
...
Lourdes
1 years ago
I agree with Thomasena, option D makes sense.
upvoted 0 times
...
Thomasena
1 years ago
I'm leaning towards option D.
upvoted 0 times
...
Linette
1 years ago
No, I believe it's option B.
upvoted 0 times
...
Marvel
1 years ago
I think the formula to extract the first three-letter segment is option A.
upvoted 0 times
...

Save Cancel
a