Salesforce Exam Salesforce Marketing Associate Topic 2 Question 8 Discussion

Actual exam question for Salesforce's Salesforce Marketing Associate exam

Question #: 8
Topic #: 2

[All Salesforce Marketing Associate Questions]

Management at Cloud Kicks wants to engage customers who have redeemed promotion codes on its website.

The associate set up a data extension so that Subscriber Key is the primary key. However, the associate notices that customers who have redeemed more than one promotion code only have one record added into the data extension.

What should the associate change to allow more than one record per subscriber key?

AAssign new subscriber keys to each promotion code redemption.

BAssign the email address as the primary key.

CAssign the promotion code field as a second primary key.

Show Suggested Answer

Suggested Answer: C

To allow more than one record per subscriber key, especially for customers who have redeemed more than one promotion code, the associate should assign the promotion code field as a second primary key. This creates a composite primary key consisting of the Subscriber Key and the Promotion Code field. With this configuration, each record is uniquely identified by the combination of the subscriber key and the promotion code, allowing multiple records for the same subscriber as long as the promotion codes are different.

by An at Mar 18, 2024, 10:02 PM

Limited Time Offer

25%

Off

Get Premium Salesforce Marketing Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Aimee

12 months ago

Haha, I can't believe they're even considering assigning new subscriber keys. Talk about overkill! Option C is definitely the way to go here, no doubt about it.

upvoted 0 times

Yesenia

11 months ago

Yeah, assigning the promotion code field as a second primary key makes the most sense.

upvoted 0 times

...

Hana

11 months ago

I agree, assigning new subscriber keys seems like too much work.

upvoted 0 times

...

Louvenia

11 months ago

Option C is definitely the way to go here, no doubt about it.

upvoted 0 times

...

Mirta

1 years ago

That makes sense, it would allow for multiple records for customers who redeem more than one promotion code.

upvoted 0 times

...

Roy

1 years ago

I believe assigning the promotion code field as a second primary key could be a better solution.

upvoted 0 times

...

Dierdre

1 years ago

But wouldn't that make it harder to track each customer's activity?

upvoted 0 times

...

Bobbye

1 years ago

I'm not sure about that. Assigning new subscriber keys for each promotion code redemption seems like a lot of extra work. I'd go with option B and use the email address as the primary key instead.

upvoted 0 times

...

Malika

1 years ago

Yeah, I agree with Avery. Option C is the clear winner here. Keeping the subscriber key as the main identifier while adding the promotion code as a secondary key is the best way to handle this scenario.

upvoted 0 times

Bettye

11 months ago

Let's update the data extension with the promotion code as a second primary key.

upvoted 0 times

...

Keith

11 months ago

Agreed, having the promotion code as a secondary key is the way to go.

upvoted 0 times

...

Audry

11 months ago

I think we should go with option C, it makes the most sense.

upvoted 0 times

...

Keena

1 years ago

I think the associate should assign new subscriber keys to each promotion code redemption.

upvoted 0 times

...

Margret

1 years ago

I think assigning the promotion code field as a second primary key could also work, as it would allow for multiple records per subscriber key.

upvoted 0 times

...

Vallie

1 years ago

I agree with Salina, having separate subscriber keys for each promotion code makes more sense.

upvoted 0 times

...

Avery

1 years ago

Hmm, I think option C is the way to go. Assigning the promotion code as a second primary key will allow multiple records per subscriber key. Seems like a logical solution to me.

upvoted 0 times