List of questions
Related questions
Question 102 - Certified Marketing Cloud Consultant discussion
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
Your answer:
0 comments
Sorted by
Leave a comment first