Exam Certified Marketing Cloud Consultant topic 1 question 6 discussion

Actual exam question from Salesforce's Certified Marketing Cloud Consultant

Question #: 6
Topic #: 1

[All Certified Marketing Cloud Consultant Questions]

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

Show Suggested Answer

Suggested Answer: C 🗳️
First Query and then data extract. Since Time is fixed so Scheduled Automation.

by dann_c8 at May 3, 2023, 8:38 p.m.

Comments

Submit Cancel

dann_c8

Highly Voted 3 months, 3 weeks ago

I had a hard time understanding why a SQL activity was necessary. Now I realize that the DE from the smart capture have all historic submission data. In order to send the records that submitted from the previous day, you have to SQL query the smart capture DE and extract the resulting DE. This makes absolute sense now.

upvoted 5 times

...

Exam Certified Marketing Cloud Consultant All Questions

View all questions & answers for the Certified Marketing Cloud Consultant exam

Exam Certified Marketing Cloud Consultant topic 1 question 6 discussion

Comments

dann_c8

SY0-701