Salesforce Certified Marketing Cloud Consultant — Question 41

Northern Trail Outfitters is interested in a solution to automate a process. They currently pull data into a spreadsheet to import into a data extension for sending.
The data warehouse can be configured to place a file daily on an SFTP.
Which three questions are relevant to determining a solution? (Choose three.)

Answer options

• A. Does someone need to be notified if an error happens on import?
• B. Will the file have more than 5,000 rows?
• C. Does the file have demographic data?
• D. Is the data file a delta or a historical file?
• E. Will the data file be placed on the SFTP at the same time daily?

Correct answer: B, D, E

Explanation

The correct answers, B, D, and E, are critical for determining the capabilities and requirements of the automation solution. Knowing if the file exceeds 5,000 rows helps assess data handling limits, while understanding if it's a delta or historical file informs how the data should be processed. Additionally, confirming the daily timing of the file placement is vital for scheduling the automation correctly. Options A and C, while potentially useful, do not directly impact the setup and functionality of the automated process.