Salesforce Certified Marketing Cloud Consultant · Free Practice Question Easy
Question 7
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?
- A Overwrite
- B Update Only
- C Add Only
- D Add/Update
Reveal correct answer
Correct answer: A
Explanation
A is the correct answer because the customer wants to refresh data each morning with the latest product catalog, and therefore, using the Overwrite import type ensures that the data extension is completely replaced with the new product catalog. This will ensure that the updated product information is accurately reflected in the data extension while removing any products that are no longer available. B and C are incorrect because these import types do not replace all data in the data extension. D is incorrect because it would result in duplicates for the products already in the data extension and does not account for products that have been removed from the catalog.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
