CRT-250 practice question 8 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" indicates the admin was attempting to use either the 'Add and Update' or 'Update Only' import type. Both of these actions require a primary key on the data extension to identify and match existing records for updating. When a data extension does not have a primary key, the system cannot perform these matching operations. The 'Overwrite' import type deletes all existing records and replaces them with the records from the import file. This action does not require matching individual records, and therefore, does not need a primary key. According to Salesforce documentation, it is the only import type available for data extensions without a primary key.
A. Add Only: This option is unavailable in the Import Wizard for a data extension that lacks a primary key, as the system cannot check for pre-existing records to prevent duplicates.
C. Add and Update: This import type explicitly requires a primary key to match incoming records with existing ones for the update operation. This is likely the action that caused the error.
D. Update Only: This import type exclusively updates existing records and therefore strictly requires a primary key to identify which specific records to modify.
1. Salesforce Help Documentation, "Import into a Data Extension": In the section describing the import process, under the "Import Type" options, the documentation states for the 'Overwrite' option: "This option is the only one available for data extensions without a primary key." This directly confirms that 'Overwrite' is the correct choice.
2. Salesforce Help Documentation, "Create a Data Extension in Marketing Cloud": When defining data extension properties, the documentation explains the role of a primary key: "A primary key uniquely identifies each row in the data extension... Use a primary key when you plan to update data in the data extension." This reinforces that update-related import actions ('Add and Update', 'Update Only') are dependent on a primary key.
Keep practicing
Take the free CRT-250 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CRT-250 practice questions
- Question 1Marketing Cloud admin is asked to determine the total number of emails sent across all of…
- Question 2Which activity should be used for multivariate content testing within Journey Builder?
- Question 3What does Marketing Cloud authenticate when a user logs in through the user interface?
- Question 4Northern Trail Outfitters (NTO) wants to limit who can receive Marketing Cloud tracking d…
- Question 5What elements of CAN-SPAM should the Marketing Cloud admin ensure are present for each Co…
- Question 6Northern Trail Outfitters has noticed an issue with their sends today. Which two links in…
