ExamTopics Logo
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Marketing Cloud Email Specialist All Questions

View all questions & answers for the Certified Marketing Cloud Email Specialist exam
Go to Exam

Exam Certified Marketing Cloud Email Specialist topic 1 question 11 discussion

Actual exam question from Salesforce's Certified Marketing Cloud Email Specialist
Question #: 11
Topic #: 1
[All Certified Marketing Cloud Email Specialist Questions]

A marketer is updating a data extension by manually importing a file. The marketer wants to ensure only new records are added to the data extension during the import process.
In which two ways should the data extension and import be configured? (Choose two.)

  • A. Select the update type ג€Overwriteג€.
  • B. Ensure the data extension has a Primary Key.
  • C. Select the update type ג€Add Onlyג€.
  • D. Select the update type ג€Add and Updateג€.
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️
by Etonam123 at June 21, 2023, 3:58 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Etonam123
1 year, 2 months ago
BD. Add only will create duplicate if the record already exists
upvoted 2 times
axb123
1 year, 1 month ago
Not if you set the primary key it won't. "Add only - The import creates records for primary keys that do not exist in the data extension and ignores records whose primary keys exist." (https://help.salesforce.com/s/articleView?id=sf.mc_es_import_into_de.htm&type=5)
upvoted 1 times
bruce_wayne69
4 months, 2 weeks ago
Yes, but since the question is framed such that we assume the two ways need to be exclusive, BD makes more sense because even if there is no Primary Key set, Add and Update will take care of the duplicate records
upvoted 1 times
2a5219f
3 weeks, 2 days ago
By "record" it means a whole row. The marketer only wants to add new rows (rows that don't currently exist), a row uniqueness is defined by the primary key, meaning this process is simply going to verify if a particular primary key is already part of the data, if yes, skip (it is not a new record), if not, add it. The ask is not to update existing records, but to add new records. So AC.
upvoted 1 times
2a5219f
3 weeks, 2 days ago
I mean BC lol.
upvoted 1 times
...
...
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago