Which workflow should meet these requirements?

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.

Which workflow should meet these requirements?
A . Triggered Automation: Import File > Group Refresh > Send Email(s)
B . Scheduled Automation: Import File > SQL Query(s) > Send Email(s)
C . Triggered Automation: Import File > SQL Query(s) > Send Email(s)
D . Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s)

View Answer

Answer: C

Explanation:

If a question is related to automation and it mentions that a file will be available in the FTP always at a specific time, your answer will be an option with a scheduled automation. Scheduled automations are used when you know the time a file is pushed into FTP and it always runs at a scheduled time. If a question is related to automation and there is an uncertainty when the file will be pushed to FTP (ex; a day before last working day / if a date falls on a weekend, it will be available on last Friday etc.), your answer will be an option with a Triggered Automation. Triggered Automation’s are fired as soon as a file hits a specific location within FTP. Transfer activity is involved when file in encrypted.