CRT-250 practice question 19 of 25
A Consultant has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today's product catalog. The product catalog is never the same; products can be added and removed. Which import type should be used?
Full set: 165 questionsThe requirement is to completely refresh a data extension daily with a new product catalog file where products can be added and removed. The 'Overwrite' import type is the only option that meets this requirement. It first deletes all existing records in the target data extension and then populates it with the records from the import file. This ensures that products removed from the catalog are no longer present in the data extension, and new products are added, making the data extension an exact mirror of the daily file.
B. Add Only: This option would only add new records and would fail to update existing product information or remove products that are no longer in the catalog.
C. Add/Update: This option would add new products and update existing ones, but it would not remove products that are no longer in the daily catalog file.
D. Update Only: This option would only update existing records. It would neither add new products from the catalog nor remove discontinued ones.
1. Salesforce Help Documentation: Import into a Data Extension in Marketing Cloud. This document details the "Update Type" options for an import activity. The 'Overwrite' option is described as: "We overwrite all records in the data extension with the records in your import file." This directly addresses the need to replace the entire dataset daily.
2. Salesforce Trailhead: Audience Data in Marketing Cloud module, Manage Data Extensions unit. This module explains the different import options. It clarifies that 'Overwrite' is used to replace the entire contents of a data extension, which is necessary when records need to be removed as part of a refresh.
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…
