Notifications
Clear all
Topic starter
04/10/2022 5:09 am
A customer will provide a single daily file on the Marketing Cloud SFTP at 3 a.m. and needs an alert if the file is NOT present on time.
The file needs to be:
* Imported iota a staging data extension.
* Separated into two different data extensions.
Which automation should meet these requirements?
- A . Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- B . File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- C . Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- D . File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
Suggested Answer: B