Câu 58: Salesforce Certified Marketing Cloud Consultant

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?

1. A. Report activity that generates Recent Send Summary report > Report delivered directly to SFTP
2. B. Data Extract activity of Tracking Extracts that combines data into required file > File Transfer Activity
3. C. SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity — đáp án hiện tại
4. D. Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity