Salesforce Certified Marketing Cloud Consultant — Question 88

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because importing into a data extension using the 'add and update' method allows for efficient handling of large datasets, ensuring that new and updated records are processed correctly without duplicates. Options A and B are less optimal as they involve lists, which may not handle large volumes as effectively, and option D would overwrite existing data, which is not necessary given the customer's requirement to only update records.