Northern Trail Outfitters receives a nightly encrypted unsub file to their Marketing Cloud SFTP from a third-party email platform. These files are used to unsubscribe existing subscribers. They do not use Email Address as Subscriber Key.
What Automation Studio Activity sequence should be used to ensure the appropriate subscribers are unsubscribed from the All Subscriber List?
A . Import File > Data Extract > File Transfer > Import File
B. File Transfer > Import File > Query > Data Extract > File Transfer > Import File
C. Import File > Query > Data Extract > File Transfer > Import File
D. File Transfer > Import File > Data Extract > File Transfer > Import File
Answer: C
Explanation:
Import File activity can be used to import the unsub file from the SFTP to a data extension.
Query activity can be used to query the data extension and update the status of the subscribers in All Subscribers list to Unsubscribed. Data Extract and File Transfer activities are not needed for this process.
References:
https://help.salesforce.com/articleView?id=sf.mc_as_import_file_activity.htm&type=5
https://help.salesforce.com/articleView?id=sf.mc_as_query_activity.htm&type=5
Latest Certified Marketing Cloud Consultant Dumps Valid Version with 220 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund