Question

The customer has these requirements for storing engagement data in their data warehouse:

• All email open and click activity must be pulled daily from the Marketing Cloud.
• Output files must meet the specific requirements for the data warehouse.
• All the activity must be provided via FTP in one file.

Which automation workflow meets the customer requirements?

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

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

C. Query activity to pull data view information > Extract activity of data extension > Transfer activity

D. Extract activity of data view tables > Query activity to create the required file > Transfer activity

Answer 1

To meet the requirements stated by the customer for engaging data, the correct automation workflow is Extract activity, followed by Query activity to format the data, and finally Transfer activity to send it via FTP.

Step-by-step explanation:

The student's question pertains to which automation workflow in the Marketing Cloud will meet a customer's specific requirements for storing engagement data in their data warehouse. The correct workflow that would fulfill all the customer's requirements is:

• Extract activity of data view tables
• Query activity to create the required file
• Transfer activity to FTP the combined file

This workflow begins with an Extract activity that sources data directly from Marketing Cloud data view tables. Subsequently, a Query activity is employed to transform and combine the data according to the warehouse's file format requirements. Finally, the Transfer activity moves the resulting file via FTP to the desired location.