A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if the file is not present on time. The file needs to be:
✑ Imported into a staging data extension.
✑ Separated into two different data extensions.
Which workflow should meet these requirements?

A. File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

B. Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

C. Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

D. File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1








 

Suggested Answer: C



No file transfer required because there is no file encryption required.

This question is in Certified Marketing Cloud Consultant Exam
For getting Salesforce Certified Marketing Cloud Consultant
















Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Salesforce. 
Trademarks, certification & product names are used for reference only and belong to Salesforce.
The website does not contain actual questions and answers from Salesforce's Certification Exams.