Salesforce Exam Marketing Cloud Consultant Topic 1 Question 95 Discussion

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. Reference: 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