<< Prev Question Next Question >>

Question 8/76

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. File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

B. Scheduled Starting Source: Data Extract > 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

Recent Comments (The most recent comments are at the top.)

Russ - Apr 26, 2022

The answer is actually C. If the file drops after 3AM, the automation will still work and there will be no error.

Question 8/76

Recent Comments (The most recent comments are at the top.)

LEAVE A REPLY

Download PDF File