MENU
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?
Suggested Answer: D
Get Premium CRT-250 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
34 comments · newest first
CA
Cassandra
11 months ago
Definitely Add and Update if you want to avoid errors!
NO
Norah
11 months ago
Wait, can you really use Overwrite without a primary key?
JO
Jospeh
12 months ago
Add Only works too, right?
EL
Elza
12 months ago
I think Overwrite is the way to go!
DE
Deonna
1 year ago
You need a primary key for Update Only.
DE
Dewitt
1 year ago
I thought Add and Update was the one that needed a primary key too, so maybe that's not it?
MA
Margurite
1 year ago
I feel like Add Only could be the answer since it doesn't need a primary key, but I'm not completely confident.
MA
Malcolm
1 year ago
I remember practicing with the Overwrite option in a similar question, but I'm not sure if it's the right choice here.
AN
Annamaria
1 year ago
I think the error means we can't use the Update Only option since it requires a primary key, right?
MA
Margurite
1 year ago
Based on the options provided, I think Add and Update might be the best choice here. That way I can add new records and update existing ones without needing a primary key.
SH
Sherman
1 year ago
I'm a bit confused on the difference between the import types. I'll need to review the details of each one to determine which one would work for a non-sendable data extension.
LA
Lavelle
1 year ago
Okay, let's see. The question says the import type being used requires a primary key, so I'm guessing I'll need to choose an import type that doesn't require a primary key. Maybe Add Only?
SH
Shannon
1 year ago
Hmm, this is a tricky one. I'll need to think carefully about the different import types and which one would work best for a non-sendable data extension.
QU
Queen
1 year ago
Hmm, I'm a bit unsure on this one. I'll have to think it through carefully to make sure I select the right option.
SH
Sherron
1 year ago
Ah, I see what they're getting at. Virus scanning is meant to protect the client machines, not necessarily speed up processing. I think I've got the right approach here.
AN
Annelle
1 year ago
Performing procedures to understand the design of internal control seems like a must-have task, but all deficiencies? Not sure about that.
LU
Luz
1 year ago
I think we also covered the differences between service registries and inventories in class. Hmmm... it may be C or D, but I'm not totally sure.
MI
Micah
2 years ago
Ooh, this one's tricky. I'll have to consult my trusty Marketing Cloud admin handbook for the answer.
CL
Clare
1 year ago
C) Add and Update
WI
Wilson
1 year ago
B) Overwrite
PA
Paola
1 year ago
A) Add Only
CA
Caitlin
2 years ago
I wonder if the admin tried turning it off and back on again. That's usually the first step in any IT troubleshooting, right?
SH
Shelba
1 year ago
A: Hopefully that solves the issue for the admin.
MA
Maia
1 year ago
B: That's correct. Option C allows the admin to add new records and update existing ones.
GL
Glendora
1 year ago
A: The admin could use option C) Add and Update.
TE
Tequila
2 years ago
C) Add and Update seems like the way to go. Let's hope it doesn't create any data duplicates, though.
TY
Tyisha
2 years ago
Ah, the old primary key conundrum. Looks like we need to get creative with our import options here.
JA
Jaime
1 year ago
D: I disagree, 'Overwrite' is the way to go here.
RO
Roy
1 year ago
C: Actually, 'Update Only' might work better for this situation.
CO
Corinne
1 year ago
B: No, I believe 'Add Only' would be the best option in this case.
SH
Shanice
1 year ago
A: I think the admin could use 'Add and Update' as the import type.
AL
Altha
2 years ago
I agree with Gilma, Add and Update would be the best option to avoid the primary key error.
GI
Gilma
2 years ago
I disagree, I believe the admin should use Add and Update instead.
PA
Paris
2 years ago
I think the admin could use Add Only.