Salesforce Certified Marketing Cloud Email Specialist — Question 9

A customer has a Send Log they are using to track the email addresses that were sent to, date and time of the send, and the name of the email sent for reporting purposes. Per best practice, the customer stores 10 days of data in their Send Log and then archives the data into another data extension that holds data for one year.
Which activity should be used to run the backup automatically?

Answer options

• A. SQL Query
• B. Import File
• C. Filter
• D. Data Extract

Correct answer: A

Explanation

The correct answer is SQL Query, as it can be scheduled to automatically select and transfer the required data from the Send Log to the archive data extension. The other options, such as Import File and Data Extract, do not provide the same level of automation for this specific task, and a Filter does not facilitate the backup process directly.