Salesforce Certified Marketing Cloud Consultant — Question 44

Northern Trail Outfitters (NTO) wants to import recent customer transaction data from their data warehouse into Marketing Cloud on a nightly basis. They plan to create a File Drop Automation to trigger an automation when a data file is transferred from the data warehouse to the import folder in their Enhanced FTP account.
NTO notes that user passwords expire every 90 days and they do not want to update their file transfer script on the data warehouse each time a password changes and they do not want to compromise security.
Which solution should the consultant recommend?

Answer options

• A. Contact the Marketing Cloud account representative to enable Single Sign-On Authentication using SAML
• B. Request SSH key authentication to be enabled for the FTP user and create an SSH Key in Key Management
• C. Enable the 'Exclude FTP Users From Password Expiration' option in Setup > Security Settings
• D. Upload data files to Marketing Cloud using SFTP instead of FTP

Correct answer: C

Explanation

The correct solution is option C, as enabling the 'Exclude FTP Users From Password Expiration' option will prevent the need to update the file transfer script every 90 days due to password changes. Option A, while helpful for security, does not address the specific issue of password management in this context. Option B introduces SSH key authentication, which is a different method but may not solve the problem of password expiration. Option D changes the transfer method but does not resolve the underlying password expiration issue.