MENU
Northern Trail Outfitters imports a daily feed of active customers into a data extension. A customer is only included in the daily feed if they meet the criteria to remain active.
Which import option should be used to ensure the data extension only contains currently active customers?
Suggested Answer: B
Get Premium Salesforce Certified Marketing Cloud Engagement Specialist (MC-202) Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
36 comments · newest first
MA
Marilynn
11 months ago
I thought Append would work too, but I guess not?
VA
Vallie
11 months ago
Totally agree with Overwrite! Keeps it clean.
UN
Una
12 months ago
Wait, can we really trust the daily feed to be accurate?
KI
Kindra
12 months ago
I think Add and Update makes more sense.
ZA
Zachary
1 year ago
Overwrite is the way to go for active customers!
DA
Daniel
1 year ago
I’m leaning towards "Overwrite" too, but I wonder if "Add and Update" could also be a valid option since it might keep the active ones while updating their status.
JE
Jess
1 year ago
I practiced a similar question, and I feel like "Append" wouldn't work here because it would just keep adding customers without removing inactive ones.
LE
Leatha
1 year ago
I'm not entirely sure, but I remember something about "Add and Update" being useful for keeping existing records while adding new ones.
MI
Miriam
1 year ago
I think the "Overwrite" option might be the right choice since it would replace the old data with the new active customers.
BO
Bobbie
1 year ago
I'm a bit confused on the differences between Append, Overwrite, and Add and Update. Can someone explain those options in a bit more detail?
EL
Elbert
1 year ago
Overwrite makes the most sense to me. That way the data extension will always reflect the current active customer list without any outdated information.
DW
Dwight
1 year ago
The Append option seems like it would just keep adding new active customers without removing the inactive ones, so that's not the right choice. I'm leaning towards Overwrite.
JA
Jacki
1 year ago
Hmm, I'm a little unsure here. I'll need to think through the implications of each option carefully before deciding.
ZO
Zona
1 year ago
This seems straightforward - I think the Overwrite option is the best choice to ensure the data extension only contains currently active customers.
EM
Emiko
1 year ago
I'm pretty sure the term 'happy day' is used in the context of scenarios, since that's where we often discuss positive user experiences.
LI
Linn
1 year ago
Hmm, I'm a bit confused on the specifics of the GVP IP Call Manager components. I'll need to review my notes to refresh my memory on the different modules and their responsibilities.
JE
Jerry
1 year ago
The question is asking for three design concepts to explain, so I would focus on the key points: a project can contain elements from multiple models, a model is a group of elements for a distributable solution, and a package is a deployment unit that may contain one or more models. Those seem to be the core concepts to cover.
LI
Lisandra
1 year ago
This one's a bit tricky, but I'm feeling confident. I'm going to go with option C - checking the Business Hours only if the 'Is Holiday' prompt returns a 'No'. That seems to align with the requirement of playing the 'busOpenPrompt' when it's not a holiday.
TA
Tawna
1 year ago
Overwrite, without a doubt. Although, I hope Northern Trail Outfitters isn't using this data extension to send emails to inactive customers. That would be a real facepalm moment.
YA
Yasuko
1 year ago
I agree, overwriting is the best option to ensure only active customers are in the data extension.
AR
Arlene
1 year ago
C) Add and Update
CH
Chauncey
1 year ago
B) Overwrite
GE
Gerald
1 year ago
A) Append
SH
Sheridan
1 year ago
Overwrite is the way to go. Why keep a bunch of inactive customers in the data extension? That's just a waste of space.
KA
Kattie
1 year ago
Add and Update could potentially mix active and inactive customers, so Overwrite is definitely the safest choice.
AN
Angella
1 year ago
Appending would just add more inactive customers, which is not what we want.
DE
Desire
1 year ago
I agree, Overwrite is the best option to ensure we only have active customers in the data extension.
EL
Elouise
2 years ago
I'm leaning towards Overwrite as well. Appending or adding updates could leave old, inactive customers in the data extension.
VE
Verlene
1 year ago
Yes, Overwrite is the safest choice to maintain a data extension with only currently active customers.
AL
Aleshia
1 year ago
Appending or adding updates could cause issues with inactive customers being included in the data extension.
DE
Deeanna
1 year ago
I agree, Overwrite will make sure that old, inactive customers are not included in the data extension.
WI
Willodean
1 year ago
I think Overwrite is the best option to ensure only active customers are in the data extension.
GI
Gilma
2 years ago
Overwrite seems like the best option to ensure the data extension only contains currently active customers. It'll replace the entire dataset instead of appending or adding updates.
VI
Vi
2 years ago
I'm not sure, but I think Overwrite might also work to ensure only active customers are in the data extension.
BE
Bernadine
2 years ago
I agree with Dorothy. Using Add and Update will ensure that only currently active customers are included in the data extension.
DO
Dorothy
2 years ago
I think the answer is C) Add and Update.