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 sent to the marketing manager each morning that contains the previous day’s submissions as a CSV attachment. Assuming that the customer has the attachments feature enabled.

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

Answer: D