Salesforce Exam Salesforce MarketingAssociate Topic 2 Question 8 Discussion

Actual exam question for Salesforce's Salesforce MarketingAssociate exam

Question #: 8
Topic #: 2

[All Salesforce MarketingAssociate 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 MarketingAssociate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Aimee

6 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

5 months ago

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

upvoted 0 times

...

Hana

5 months ago

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

upvoted 0 times

...

Louvenia

5 months ago

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

upvoted 0 times

...

Mirta

6 months ago

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

upvoted 0 times

...

Roy

6 months ago

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

upvoted 0 times

...

Dierdre

6 months ago

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

upvoted 0 times

...

Bobbye

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

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

5 months ago

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

upvoted 0 times

...

Keith

5 months ago

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

upvoted 0 times

...

Audry

5 months ago

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

upvoted 0 times

...

Keena

6 months ago

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

upvoted 0 times

...

Margret

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

7 months ago

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

upvoted 0 times

...

Avery

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