ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 58 - Certified Marketing Associate discussion

Report
Export

A marketing associate at Cloud Kicks has a list of contacts that needs to be imported into a data extension which has the following three attributes:

* ContactID contains the unique identifier for the contact

* MobileNumber contains the mobile number of the contact

* EmailAddress contains the email address of the contact

Which option should the associate use as the primary key of the data extension to ensure no duplicates are included in the data?

A.
EmailAddress
Answers
A.
EmailAddress
B.
MobileNumber
Answers
B.
MobileNumber
C.
ContactID
Answers
C.
ContactID
Suggested answer: C

Explanation:

For the marketing associate at Cloud Kicks importing a list of contacts into a data extension with attributes like ContactID, MobileNumber, and EmailAddress, the best choice for the primary key would be ContactID. The primary key in a data extension is used to ensure uniqueness of each record, preventing duplicate entries. Given that ContactID is described as the unique identifier for each contact, it naturally serves as the most appropriate choice for the primary key.

Using ContactID as the primary key guarantees that each contact will be represented only once in the data extension, regardless of whether they might have multiple email addresses or mobile numbers over time. This approach aligns with best practices in database management and data integrity.

asked 23/09/2024
ML MASANE
46 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first