How can the marketer achieve this? A marketer is importing a file - ProProfs Discuss
Topics-
Products +
     

How can the marketer achieve this? A marketer is importing a file using the import wizard and wants to ensure that only new records are added during the import process. 



A. Select the update type Overwrite
B. Select the update type Add Only
C. Ensure that the data extension contains a primary key
D. Select the update type Add and Update

This question is part of Certified Marketing Cloud Email Specialist - PART 1
Asked by Catherine halcombe, Last updated: Mar 18, 2019

+ AnswerRequest Answer
...

6 Answers

N. Jarah

N. Jarah

Answered on Nov 14, 2019

There are two correct answers that are available for this question. The first thing that you have to do is to select the update and type add only. After that, you can ensure that the data extension contains a primary key to be sure that only the new data will be added during the import process.

You can already imagine what will happen if all of the data will be imported. This would result in some data becoming mixed. Some may not be overwritten, and it will be more challenging to remove the duplicated data. It will also make the data harder to analyze and understand.

 Reply

John Adney

John Adney

Answered on Aug 18, 2017

Ensure data extension has a primary key and for me it is Add Only

 Reply

kratigarg

Kratigarg

Answered on Jul 10, 2017

Correct Answers:

B. Select the update type Add Only

C. Ensure that the data extension contains a primary key

Refer:https://help.marketingcloud.com/en/documentation/exacttarget/subscribers/data_extensions_and_data_relationships/data_extension_import_wizard/

 Reply

cirodefelice

Cirodefelice

Answered on Jun 14, 2017

Ensure data extension has a primary key and for me it is Add Only
 Reply

santro

Santro

Answered on Apr 10, 2017

Select the update type Add Only
 Reply

John Smith

John Smith

Answered on Nov 15, 2016

Ensure that the data extension contains a primary key
2. Select the update type Add and Update
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.