Question

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

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

C. File Drop 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

Answer 1

The correct workflow to meet the requirements is option D: File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1.

Step-by-step explanation:

The correct workflow to meet the requirements is option D: File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1.

This workflow ensures that a single daily file on the Marketing Cloud SFTP is imported into a staging data extension.

It also separates the file into two different data extensions using a Filter Activity before running SQL Query Activity 1.

By setting up the workflow as a File Drop Automation, the system will generate an alert if the file is not present on time, ensuring that the customer is aware of any delays in the upload.