Salesforce Certified Marketing Cloud Consultant — Question 5

A financial company wants to use Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week. The company has shared the following:
✑ Payments.csv will arrive on the Enhanced SFTP each Monday at 1 a.m.
✑ Payments.csv will be encrypted.
✑ Payments.csv will contain data from the previous week.
✑ Late payment notices will be sent each Monday at noon.
✑ They need to receive a file containing customers who opened or clicked on the late payment notice email within five days after send.
Which automation sequence represents a viable solution?

Answer options

• A. File Transfer > Import File > Filter > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
• B. Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
• C. File Transfer > Import File > Filter > Wait > Send Email > SQL Query > Wait > Data Extract > File Transfer
• D. File Transfer > File Transfer > Import File > SQL Query > Wait > Send Email > SQL Query > File Transfer

Correct answer: B

Explanation

Option B is correct as it follows the required sequence of importing the file first, running a SQL query to determine which customers to send the email to, and then sending the email. The other options do not align with the necessary timing and order of operations, such as sending emails before the data has been processed or failing to wait appropriately after actions.