Salesforce Certified Marketing Cloud Consultant — Question 48

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?

Answer options

• 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

Correct answer: C

Explanation

The correct answer is C because it utilizes a Scheduled Automation with the Import File Activity to ensure it checks for the file at the specified time. Options A and D use File Drop Automation, which is not suitable for checking the presence of a file at a specific time, and option B includes a File Transfer Activity that is unnecessary for this requirement.