Notifications
Clear all

The file needs to be:

1 Posts
1 Users
0 Likes
59 Views
Harris
(@ripaharris)
Noble Member
Joined: 7 months ago
Posts: 383
Topic starter  

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

Show Answer Hide Answer

Suggested Answer: B

   
Quote
Share: