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 questionsThe 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.
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.
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.
Keep practicing
Take the free MARKETING-CLOUD-ADMINISTRATOR practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MARKETING-CLOUD-ADMINISTRATOR practice questions
- Question 1Northern Trail Outfitters wants to bring subscriber data from its data warehouse into Mar…
- Question 3A Marketing Cloud admin wants to create an SFTP User for the first time. Which two consid…
- Question 4A marketing Cloud admin wants to ensure sensitive information needed for email sends is N…
- Question 5An email manager was anticipating a test email to arrive in their inbox. Where in Email S…
- Question 6A user asks a Marketing Cloud admin to update and increase their session timeout setting.…
- Question 7A Marketing Cloud admin is configuring Social Studio to manage Northern Trail Outfitters …
