The customer has the following requirements for storing engagement data in their data warehouse:
✑ All email open and click activity must be pulled daily from Marketing Cloud.
✑ Output files must meet the specific requirements for the data warehouse.
✑ All the activity must be provided via SFTP in one file.
Which automation workflow meets the customer requirements?

A. Report activity that generates Recent Send Summary report > Report delivered directly to SFTP

B. Data Extract activity of Tracking Extracts that combines data into required file > File Transfer Activity

C. SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity

D. Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity








 

Suggested Answer: C





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.