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 questionsThe 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.
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.
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.
Keep practicing
Take the free MC-101 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MC-101 practice questions
- Question 1Northern Trail Outfitters (NTO) wants more insight into website traffic and behavior gene…
- Question 2A marketing associate needs to import a CSV file into a data extension. Which delimiter s…
- Question 3Northern Trail Outfitters created a new team to oversee its marketing strategy. They want…
- Question 4The marketing team at Northern Trail Outfitters is exploring helpful features from Salesf…
- Question 5Management at Northern Trail Outfitters wants to run a new campaign and has asked the mar…
- Question 6Management at Northern Trail Outfitters would like to start sending personalized emails t…
