Salesforce Updated MCE-Admn-201 Exam Questions and Answers by casey

The File Transfer Activity can be used to decrypt a file on the SFTP server using a PGP key. This activity prepares the file for importing into Marketing Cloud. The other activities do not have the option to decrypt a file.

 To clear inactive data stored in data extensions after 12 months, NTO should apply a row-based retention to each data extension as it is created, set to 12 months. This will delete any records that have not been modified in the last 12 months. Row-based retention can be applied to individual data extensions or data extension templates

To limit the distribution of Marketing Cloud tracking data via email to only those within the ntoretail.com domain:

Add a Domain to the Export Email Whitelist: Configure the settings to include 'ntoretail.com' in the export email whitelist. This ensures that only email addresses from this domain can receive exported data.

Enforce Export Email Whitelist: Activate this setting to strictly enforce the whitelist during data exports, preventing any non-whitelisted domains from receiving tracking data.

The error in the File Drop Automation is due to the filename pattern not matching exactly because of additional seconds and milliseconds in the filename. To resolve this issue:

Modify the Import File activity to use the %%FILENAME_FROM_TRIGGER%% personalization string. This ensures that the Import File activity dynamically accepts the filename exactly as it is uploaded to the SFTP location.

Update the filename pattern in the automation setup to avoid hardcoding the date format and instead rely on the filename that triggered the automation.

By using %%FILENAME_FROM_TRIGGER%%, the automation becomes flexible and will correctly handle any file name that matches the initial pattern triggering the automation, regardless of additional timestamp details.