Notifications
Clear all
Topic starter
21/07/2022 11:25 pm
A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if the file is not present on time. The file needs to be: Imported into a staging data extension. Separated into two different data extensions.
Which workflow should meet these requirements?
- A . Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- B . Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- C . File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- D . File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
Suggested Answer: B