Salesforce Certified Marketing Cloud Consultant — Question 24

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?

Answer options

• 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

Correct answer: C

Explanation

Option C is correct because it effectively pulls data view information using SQL Query Activity, extracts it with Data Extract Activity, and then transfers it via File Transfer Activity, meeting all requirements. The other options either do not consolidate the data correctly or do not utilize the required methods for file transfer as specified by the customer.