Marketing-Cloud-Consultant Exam Dumps | A customer will provide a single daily file on the Marketing Cloud SFTP at 3 a.m. and needs an alert

<< Prev Question Next Question >>

Question 15/36

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

C. File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

D. File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

Question 15/36

LEAVE A REPLY

Download PDF File