MARKETING-CLOUD-ADMINISTRATOR practice question 20 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 automation is failing because the Import File activity is configured with a static date pattern (%%Year%%%%Month%%%%Day%%) that does not match the actual filenames, which include more precise timestamps. Using the %%FILENAMEFROMTRIGGER%% substitution string in the Import File activity's name field dynamically pulls the exact name of the file that initiated the automation. This ensures the import activity always targets the correct file, regardless of the specific timestamp.

Why Incorrect

B. The issue is a file name mismatch, not duplication. The file already has a unique date and time stamp which is causing the problem with the static pattern.
C. If the file were in the wrong subfolder, the File Drop trigger would not have initiated the automation in the first place. The failure is at a later step.
D. This describes the desired outcome, but option A provides the specific technical mechanism (%%FILENAMEFROMTRIGGER%%) within Automation Studio to achieve it.

References

1. Salesforce Help, Automation Studio, "Filename Patterns for Triggers and Data Extracts": This document explains how to use filename patterns. It states, "To use the name of the file that triggered the automation, enter %%FILENAMEFROMTRIGGER%%." (Section: Substitution Strings).

2. Salesforce Help, Automation Studio, "Configure an Import File Activity": This guide details the configuration options for the Import File activity, including the "File Naming Pattern" field where %%FILENAMEFROMTRIGGER%% would be used.

Scroll to Top