Discuss Salesforce Marketing Cloud Intelligence Accredited Professional (AP-215) Exam Topic 1 Question 6

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?

ALEFT(EXTRACT(csy['campaign_name]],~',0),3)

BEXTRACT(csv[campaign_name!;@',1)

CEXTRACT(csv[campaign_name'],---,0)

DEXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0)

ELEFT(EXTRACT(csv[campaign_name'}/---',1),3)

Suggested Answer: B

Get Premium Marketing Cloud Intelligence Accredited Professional (AP-215) Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

36 comments · newest first

Alecia 11 months ago

I doubt any of these will give the right output.

Kenneth 11 months ago

Wait, are we sure these formulas are correct?

Marshall 12 months ago

Definitely going with A, it seems straightforward.

Sueann 12 months ago

I think B might work too, but not sure.

Ronny 1 year ago

Looks like option A is the best choice!

Avery 1 year ago

I vaguely remember that LEFT is used for getting characters from the start, so maybe option E could work too, but I’m not sure about the EXTRACT part.

Sherill 1 year ago

I’m leaning towards option D because it seems to be using EXTRACT correctly, but I’m not entirely confident about the parameters.

Kallie 1 year ago

I think we had a similar question where we needed to get parts of a string. I feel like option A might be close, but I can't recall the exact syntax.

Kenneth 1 year ago

I remember we practiced extracting substrings, but I'm not sure if LEFT or EXTRACT is the right function here.

Gearldine 1 year ago

I'm not entirely sure about this one. The different options seem similar, but I want to make sure I select the right formula to get the desired outcome.

Dortha 1 year ago

Okay, let me break this down. I need to find a function that can extract the first 3 characters from the 'campaign_name' field. I think I can figure this out.

Jaime 1 year ago

Hmm, I'm a bit confused by the different options. I'll need to carefully read through each one and think it through step-by-step.

Herman 1 year ago

This looks like a straightforward string manipulation problem. I think I can handle this one.

Mariann 1 year ago

The key here is understanding how to use the EXTRACT function properly. I'll need to pay close attention to the syntax and parameters.

Kathrine 1 year ago

Okay, I think I've got a handle on this. The key is to find an authentication solution that doesn't rely solely on the signed request from Salesforce, since the security team has deemed that insufficient.

Gussie 1 year ago

I'm a bit confused by the wording of the options. I'll need to read through them a few times to make sure I understand the differences between temporary and permanent prepayments. This is going to require some careful thinking.

Shonda 1 year ago

I think we did a similar question on verifying message sources in class, and I recall that logging all messages might help prove integrity.

Jesusita 2 years 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?

Rolland 2 years 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!

Aaron 2 years 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.

Norah 2 years 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.

Tijuana 2 years ago

↳ replying to Norah

I agree, option D seems like the most logical choice for extracting the desired values.

Loren 2 years ago

↳ replying to Norah

I think option D looks like the correct formula to extract the first three-letter segment.

Wade 2 years 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.

Glennis 2 years ago

↳ replying to Wade

I think you're right, option A should do the trick.

Glennis 2 years ago

↳ replying to Wade

I agree, option A seems to be the correct choice.

Katlyn 2 years ago

I think Robin has a point. Extracting first, then using LEFT to get the first three letters makes sense.

Craig 2 years ago

Hmm, but E) LEFT(EXTRACT(csv[campaign_name'}/---',1),3) also returns three letters, exactly what we need.

Dulce 2 years ago

I agree with Chris, nested EXTRACT sounds logical. The campaign name structure fits it well.

Estrella 2 years ago

Not sure about that, I feel EXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0) is a better option.

In 3 years ago

Yeah, I think LEFT(EXTRACT(csy['campaign_name]],~',0),3) might be the right choice.

Kenneth 3 years ago

The question seems tricky, extracting segments like that can be complex.

Lourdes 3 years ago

I agree with Thomasena, option D makes sense.

Thomasena 3 years ago

I'm leaning towards option D.

Linette 3 years ago

No, I believe it's option B.

Marvel 3 years ago

I think the formula to extract the first three-letter segment is option A.

Salesforce Marketing Cloud Intelligence Accredited Professional (AP-215) Exam - Topic 1 Question 6 Discussion