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

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?

Show Suggested Answer Hide 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.


Contribute your Thoughts:

Aimee
10 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
10 months ago
Yeah, assigning the promotion code field as a second primary key makes the most sense.
upvoted 0 times
...
Hana
10 months ago
I agree, assigning new subscriber keys seems like too much work.
upvoted 0 times
...
Louvenia
10 months ago
Option C is definitely the way to go here, no doubt about it.
upvoted 0 times
...
...
Mirta
10 months ago
That makes sense, it would allow for multiple records for customers who redeem more than one promotion code.
upvoted 0 times
...
Roy
11 months ago
I believe assigning the promotion code field as a second primary key could be a better solution.
upvoted 0 times
...
Dierdre
11 months ago
But wouldn't that make it harder to track each customer's activity?
upvoted 0 times
...
Bobbye
11 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
11 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
10 months ago
Let's update the data extension with the promotion code as a second primary key.
upvoted 0 times
...
Keith
10 months ago
Agreed, having the promotion code as a secondary key is the way to go.
upvoted 0 times
...
Audry
10 months ago
I think we should go with option C, it makes the most sense.
upvoted 0 times
...
...
Keena
11 months ago
I think the associate should assign new subscriber keys to each promotion code redemption.
upvoted 0 times
...
Margret
11 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
11 months ago
I agree with Salina, having separate subscriber keys for each promotion code makes more sense.
upvoted 0 times
...
Avery
12 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
Chauncey
11 months ago
Yes, that makes sense. Assigning the promotion code as a second primary key would definitely solve the issue.
upvoted 0 times
...
Fidelia
11 months ago
Definitely, option C is the way to go for this scenario.
upvoted 0 times
...
Maryann
11 months ago
It's a good solution to ensure accurate customer data in the data extension.
upvoted 0 times
...
Cletus
11 months ago
I agree, option C does seem like the best solution. It would allow for multiple records per subscriber key.
upvoted 0 times
...
Chauncey
11 months ago
That way, customers who redeem multiple promotion codes will have all their data captured.
upvoted 0 times
...
Gilma
11 months ago
It's important to allow multiple records per subscriber key.
upvoted 0 times
...
Lavonna
11 months ago
Assigning the promotion code as a second primary key makes sense.
upvoted 0 times
...
Beula
11 months ago
I agree, option C does seem like the best choice here.
upvoted 0 times
...
...
Gary
12 months ago
I disagree, I believe assigning the email address as the primary key would be a better solution.
upvoted 0 times
...
Salina
1 years ago
I think the associate should assign new subscriber keys to each promotion code redemption.
upvoted 0 times
...

Save Cancel