Non-sendable Data Extension Import: Primary Key Requirement
Question
A Marketing Cloud admin is using the Import Wizard to import data into a non-sendable data extension, but receives an error indicating the import type being used requires a primary key.
Which import type could the admin use instead?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C.B
When importing data into a Marketing Cloud data extension using the Import Wizard, the type of import selected determines how the data is added to the data extension. In this scenario, the Marketing Cloud admin is attempting to import data into a non-sendable data extension and is receiving an error indicating that a primary key is required. This error occurs because the import type selected requires a primary key field to be defined in the data extension.
A primary key is a unique identifier for each record in a data extension, and it is used to ensure that there are no duplicate records. When importing data into a data extension, it is important to define a primary key to prevent duplicates.
The import types available in the Import Wizard are as follows:
Add and Update: This import type allows you to add new records and update existing records based on the primary key field.
Overwrite: This import type overwrites existing records in the data extension with the imported data.
Add Only: This import type only adds new records to the data extension and does not update existing records.
In this scenario, since the non-sendable data extension does not have a primary key defined, the admin cannot use the Add and Update import type. The Overwrite import type may not be appropriate if the admin does not want to delete existing data in the data extension. Therefore, the correct answer is C, the Add Only import type, which allows the admin to add new data to the data extension without requiring a primary key.
