Which three questions are relevant to determining a solution?

Northern Trail Outfitters in interested in a solution to automate a process. They currently pull data into a spreadsheet to import into a 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 3 answers
A . Is the data file a delta or a historical file
B. Does the data extension have a data relationship?
C. Will the file have more than 5,000 rows?
D. Will the data file be placed on the SFTP at the same time daily?
E. Does someone need to be notified if an error happens on import?

Answer: A,D,E

Explanation:

Three questions that are relevant to determining a solution for automating a process of importing data from a data warehouse into Marketing Cloud are:

✑ Is the data file a delta or a historical file? This question will help determine how to handle existing records and avoid duplication or overwrite. A delta file contains only new or updated records, while a historical file contains all records regardless of changes.

✑ Will the data file be placed on the SFTP at the same time daily? This question will help determine how to schedule an automation or trigger an event based on file drop. If the data file is placed on the SFTP at different times, then a File Drop Automation may be more suitable than a Scheduled Automation.

✑ Does someone need to be notified if an error happens on import? This question will help determine how to handle errors and exceptions during import. If someone needs to be notified, then an email notification activity or a verification activity may be added to the automation.

Whether the data extension has a data relationship or not is not relevant to determining a solution for importing data, as it is only used for creating relationships between data extensions in Email Studio. Whether the file has more than 5,000 rows or not is not relevant to determining a solution for importing data, as it does not affect how data is imported or processed.

References:

https://help.salesforce.com/s/articleView?id=sf.mc_as_file_drop_automation_studio_triggers.htm&type=5

https://help.salesforce.com/s/articleView?id=sf.mc_as_import_file_activity.htm&type=5