Which automation workflow will accomplish this?

A customer is collecting data from a Smart Capture form that stores submissions in a data extension. The customer wants an email was sent to the marketing manager each morning that contains the previous days submissions as a CSV attachment. Assuming that the customer has the attachments feature enabled.

Which automation workflow will accomplish this?
A . Scheduled Automation: Data Extract > SQL Query > Transfer File > Send Email
B . Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email
C . Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email
D . Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email

View Answer

Answer: C

Explanation:

First Query and then data extract. Since Time is fixed so Scheduled Automation.