Salesforce Certified Marketing Cloud Email Specialist — Question 81

The marketing team at a bank needs to receive a file of all subscribers who were sent payment reminder emails and opened them each week. The file needs to be encrypted and placed on the bank's external SFTP.
How should the scheduled automation be configured to achieve this?

Answer options

• A. Filter Activity > File Transfer Activity > Data Extract Activity
• B. Filter Activity > SQL Query Activity > File Transfer Activity
• C. SQL Query Activity > Data Extract Activity > File Transfer Activity
• D. Data Extract Activity > SQL Query Activity > File Transfer Activity

Correct answer: C

Explanation

The correct answer is C because the SQL Query Activity is required to retrieve the relevant subscriber data based on the criteria of opened emails. Following this, the Data Extract Activity formats the data, and the File Transfer Activity securely uploads the encrypted file to the SFTP. The other options do not sequence the activities effectively to meet the requirements.