Question 1
IntermediateSubscriber and Data Management · Import data into Marketing Cloud
Northern Trail Outfitters (NTO) manages a master subscriber database in an external legacy system. Every night, a file containing the entire customer base (active and inactive) is pushed to the Marketing Cloud Enhanced FTP. NTO wants to ensure that the 'Master_Customers' Data Extension in Marketing Cloud exactly matches this external file every morning, adding new records, updating existing ones, and removing those no longer in the file. Which Import Definition Update Type should the administrator select to achieve this efficiently?
Answer and explanation
Correct answer: C
The 'Overwrite' action completely clears the existing data in the Data Extension and replaces it with the data from the import file. This is the most efficient way to ensure the Data Extension is an exact mirror of the external source file, handling additions, updates, and essentially 'deletions' (by virtue of not being re-imported) in a single step.
