MC-101 practice question 17 of 25

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…

Full set: 122 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?
Answer options
A: Assign new subscriber keys to each promotion code redemption.
B: Assign the email address as the primary key.
C: Assign the promotion code field as a second primary key. Correct answer
Correct Answer:
C. Assign the promotion code field as a second primary key.
Explanation

The core issue is that a primary key must be unique for each record in a data extension. By using only the Subscriber Key as the primary key, each subscriber can only have one record. When a subscriber redeems a second code, the new data overwrites the existing record because the primary key value is the same. To track each redemption as a separate event, a composite primary key is required. By adding the promotion code field as a second primary key, the uniqueness of a record is now determined by the combination of the Subscriber Key and the Promotion Code. This allows a single subscriber to have multiple records, provided each record has a different promotion code.

Why Incorrect

A. Assign new subscriber keys to each promotion code redemption. This is incorrect because it would create duplicate contacts for the same individual, breaking the single customer view and leading to data management problems.
B. Assign the email address as the primary key. This does not solve the problem. A customer typically uses the same email address, so this would still result in records being overwritten, just like using Subscriber Key.

References

1. Salesforce Help, Primary Key: "A primary key is a special column or combination of columns that uniquely identifies each record in a data extension... When you select more than one field as part of a primary key, it is called a composite key. For example, you can use a composite key to uniquely identify a subscriber by their SubscriberKey and a unique JobID for a send." This document directly supports the use of a composite key (Option C) to uniquely identify records based on more than one attribute.

2. Salesforce Help, Create a Data Extension in Marketing Cloud: Under the "Primary Keys" section, the documentation explains, "Use a primary key to ensure that the data extension doesn't contain duplicate records... When a data extension has a primary key, import and API operations can reference the primary key to update existing records." This clarifies why the overwrite behavior is occurring and how changing the key structure is the correct solution.

Scroll to Top