Salesforce Certified Marketing Cloud Consultant · Free Practice Question Medium
Question 14
A customer provides a file containing only new and updated subscriber records exported from its marketing database. The file will be uploaded to the customer's Enhanced FTP automatically at 3 a.m. daily. The customer requires that the import completes prior to 4 a.m. On average, the file will contain about two million rows of data each day. Based on the customer's requirements and recommended best practices, how should the daily file be imported?
- A Import the file into a list, using the update only method.
- B Import the file into a list, using the add and update method.
- C Import the file into a data extension, using the add and update method.
- D Import the file into a data extension, using the overwrite method.
Reveal correct answer
Correct answer: C
Explanation
C is the correct answer because it is recommended best practice to import data into a data extension rather than a list when dealing with large quantities of data, such as the two million rows of data in this scenario. Importing data into a data extension also allows for more flexibility in how the data can be used and manipulated within Marketing Cloud. Additionally, using the add and update method ensures that new subscribers are added and existing subscribers are updated without overwriting any existing data. Options A and B only allow for updates, while option D would overwrite any existing data in the data extension.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.
