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








 

Suggested Answer: C



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

This question is in Certified Marketing Cloud Consultant Exam
For getting Salesforce Certified Marketing Cloud Consultant
















Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Salesforce. 
Trademarks, certification & product names are used for reference only and belong to Salesforce.
The website does not contain actual questions and answers from Salesforce's Certification Exams.