Salesforce Certified Marketing Cloud Consultant — Question 63

A customer needs to import data from an SFTP site. The customer wants to:
✑ Segment the contents of the file and then send emails.
✑ Transfer the file to the SFTP site at various times daily.
✑ Send to data extensions.
What sequence of automation activities should meet these requirements?

Answer options

• A. File Drop: Import File > Group Refresh > Send Email(s)
• B. Scheduled: Import File > SQL Query(s) > Send Email(s)
• C. File Drop: Import File > SQL Query(s) > Send Email(s)
• D. Scheduled: Transfer File > Import File > SQL Query(s) > Send Email(s)

Correct answer: C

Explanation

The correct answer is C because it allows for the file to be imported and then processed using SQL queries before sending emails, fulfilling the requirements of segmenting and sending. Option A uses Group Refresh, which is not necessary, and Option B does not consider the need for scheduled transfers. Option D involves transferring the file but does not align with the requirement of segmenting the contents before sending emails.