Salesforce Certified Marketing Cloud Consultant — Question 53

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?

Answer options

• 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

Correct answer: C

Explanation

The correct answer, C, is a Scheduled Automation that efficiently runs a SQL Query to gather the previous day's data, performs a Data Extract, and then transfers the file before sending it via email. Option A is incorrect because it extracts data before querying, which wouldn't access the latest submissions. Option B is wrong as it suggests a Triggered Automation, which is not suitable for daily scheduled tasks. Option D fails for the same reason as it also relies on a Triggered Automation.