CRT-250 practice question 16 of 25

A Marketing Cloud Administrator noticed a File Drop Automation has been falling on the Import File activity. The automation is configured with a…

Full set: 165 questions
A Marketing Cloud Administrator noticed a File Drop Automation has been falling on the Import File activity. The automation is configured with a filename pattern, so the filename is expected to begin with customer import_. The import is configured to look for a file named Customer import %%Year%%%% Month%%%%Day%%.csv, however, the admin notices the filenames Include seconds and milliseconds what should the admin do to fix the issue?
Answer options
A: use %%FILENAME_FROM_TRIGGER%% in the Import File Activity Correct answer
B: Make sure the team has a date stamp to avoid duplication
C: Make sure the files placed on the correct subfolder within the SFTP
D: Use the exact file name used for the trigger in the Import File Activity
Correct Answer:
A. use %%FILENAME_FROM_TRIGGER%% in the Import File Activity
Explanation

The core issue is a mismatch between the static filename pattern configured in the Import File activity (Customerimport%%Year%%%%Month%%%%Day%%.csv) and the actual, more detailed filename that triggers the automation (which includes seconds and milliseconds). The %%FILENAMEFROMTRIGGER%% substitution string is specifically designed for this scenario. It dynamically populates the Import File activity with the exact name of the file that initiated the File Drop automation, ensuring the activity always targets the correct file, regardless of the precise timestamp.

Why Incorrect

B. Make sure the team has a date stamp to avoid duplication: The problem is not duplication; it's a filename mismatch. The team is already using a timestamp, but the Import activity's configuration cannot handle its level of detail.
C. Make sure the files placed on the correct subfolder within the SFTP: The automation is triggering but failing on the import step. This indicates the file is in the correct monitored location; otherwise, the automation would not start at all.
D. Use the exact file name used for the trigger in the Import File Activity: This statement is conceptually correct but technically imprecise. The method to use the exact filename dynamically is by using the %%FILENAMEFROMTRIGGER%% substitution string, which is what option A specifies.

References

1. Salesforce Help Documentation, Marketing Cloud Engagement, Automation Studio, "Use a File Drop Starting Source": This document explicitly states, "To use the name of the file that triggers the automation, enter %%FILENAMEFROMTRIGGER%% in the File Naming Pattern field." This directly validates that using this substitution string is the correct procedure for an Import File activity within a File Drop automation.

2. Salesforce Help Documentation, Marketing Cloud Engagement, Automation Studio, "Import File Activity": In the section "Configure the Activity," the documentation details the "File Naming Pattern" field. It explains that this field can accept substitution strings to dynamically identify files, which is the principle behind the correct answer. The use of %%FILENAMEFROMTRIGGER%% is the specific application of this principle for triggered automations.

Scroll to Top