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

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