Salesforce-Marketing-Cloud-Engagement-Administrator Practice Test
Salesforce Spring 25 Release 157 Questions
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
C. File Drop Automation: Import File Activity > SQL Query Activity1 > SQL Query Activity 2
D. File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL
Query Activity 1
C. File Drop Automation: Import File Activity > SQL Query Activity1 > SQL Query Activity 2
Explanation:
The correct answer is C because File Drop Automation can be used to trigger an
automation when a file is dropped on the SFTP, and Import File Activity and SQL Query
Activities can be used to import and separate the data into different data extensions. A is
incorrect because Scheduled Automation cannot check if the file is present on time. B is
incorrect because Scheduled Automation cannot trigger an alert if the file is not present. D
is incorrect because Filter Activity cannot separate the data into different data extensions.