MARKETING-CLOUD-ADMINISTRATOR practice question 2 of 25

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?

Full set: 165 questions
Answer options
A: Add Only
B: Overwrite Correct answer
C: Add and Update
D: Update Only
Correct Answer:
B. Overwrite
Explanation

The error "import type being used requires a primary key" occurs when using 'Add and Update' or 'Update Only' on a data extension without a primary key. These import types need a unique identifier to find existing rows to update. The 'Overwrite' import type does not require a primary key because it completely replaces all existing data in the data extension with the data from the import file. This is a viable alternative when granular updates are not possible due to the lack of a primary key.

Why Incorrect

A. Add Only: While this option doesn't require a primary key, it would append all records, potentially creating duplicates on subsequent imports, which is often undesirable. 'Overwrite' provides a clean slate.
C. Add and Update: This import type requires a primary key to determine whether to add a new record or update an existing one. It is a cause of the error.
D. Update Only: This import type requires a primary key to locate the specific records that need to be updated. It is also a cause of the error.

References

1. Salesforce Help. (2023). Import Into a Data Extension. Salesforce, Inc. This documentation details the different import types, stating, "For the Add and Update and Update Only types, the data extension must have a primary key." It also describes 'Overwrite' as an option that replaces all records.

Scroll to Top