Which order of Automation Studio activities should be recommended?

A customer wants to capture and categorize email Not Sent events and begin identifying trends. They want to keep the data in Marketing Cloud and run queries against the dataset. The customer created a data extension to receive the information.

Which order of Automation Studio activities should be recommended?
A . Data Extract with the Data Extension Extract type > File Transfer to Safehouse > File Transfer unzip > SQL Query
B. SQL Query > Data Extract with the Data Extension Extract type > File Transfer to Safehouse > Import File
C. Data Extract with the Tracking Extract type > File Transfer from Safehouse > File Transfer unzip > Import File
D. Data Factory Utility > File Transfer from Safehouse > Import File > Data Extract with Tracking Extract type

View Answer

Answer: C

Explanation:

To capture and categorize email Not Sent events and insert them into a data extension using Automation Studio, Northern Trail Outfitters should use the following order of activities:

✑ Data Extract with the Tracking Extract type. This activity will extract tracking data, such as Not Sent events, from Marketing Cloud and place a zipped file in the Safehouse.

✑ File Transfer from Safehouse. This activity will move the zipped file from the Safehouse to an Enhanced FTP location.

✑ File Transfer unzip. This activity will unzip the file and place it in an Enhanced FTP location.

✑ Import File. This activity will import the file into a data extension.

Data Extension Extract is not a valid extract type for tracking data. SQL Query is not an activity that can insert data into a data extension from a file. Data Factory Utility is not a valid activity in Automation Studio.

References:

https://help.salesforce.com/s/articleView?id=sf.mc_as_data_extract_activity.htm&type=5

https://help.salesforce.com/s/articleView?id=sf.mc_as_file_transfer_activity.htm&type=5

https://help.salesforce.com/s/articleView?id=sf.mc_as_import_file_activity.htm&type=5