Salesforce Certified Marketing Cloud Engagement Consultant Online Practice Questions

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

Explanation:
To capture open-ended feedback from customers via SMS and write it to a data extension, Northern Trail Outfitters should use a text-response message template with embedded AMPscript to capture the response. A text-response message template is a template that allows marketers to send a text message to a mobile number and receive a reply. AMPscript is a scripting language that allows marketers to perform complex tasks within messages, such as inserting data into a data extension.
References:
https://help.salesforce.com/s/articleView?id=sf.mc_moc_text_response.htm&type=5
https://help.salesforce.com/s/articleView?id=sf.mc_es_ampscript_overview.htm&type=5

Explanation:
A query activity is an automation studio activity that allows querying data from data extensions or data views using SQL statements. A data extension entry source is a journey builder entry source that allows injecting contacts into a journey based on a data extension. Journey activities are actions that occur within a journey, such as sending an email or updating a contact attribute. By using a query activity to filter contacts who have not made a purchase in the last six months from their order data extension, NTO can create a sendable data extension with those contacts and use it as a data extension entry source for their journey. Then, by using journey activities, they can communicate the same
message across all channels to those contacts.
References:
https://help.salesforce.com/articleView?id=sf.mc_as_sql_query_activity.htm&type=5 https://help.salesforce.com/articleView?id=sf.mc_jb_data_extension_entry_source.htm&typ e=5 https://help.salesforce.com/articleView?id=sf.mc_jb_journey_activities.htm&type=5

Explanation:
To import new contacts gathered from an external web form at high frequency into Marketing Cloud, Northern Trail Outfitters should perform a daily bulk export to SFTP for import via automation. This will allow them to batch the contacts into one file per day and import them into Marketing Cloud using an automation that runs at a scheduled time.
References: https://help.salesforce.com/s/articleView?id=sf.mc_as_import_activity.htm&type=5

Explanation:
A synchronized data extension is a data extension that is automatically populated with data from Sales Cloud objects using Marketing Cloud Connect. A query activity is an automation studio activity that allows querying data from data extensions or data views using SQL statements. A Salesforce data extension is a type of data extension that stores data imported from Sales Cloud reports or campaigns using Marketing Cloud Connect. By querying synchronized data extensions using a query activity to a Salesforce data extension, the customer can segment contacts based on complex criteria without relying on Sales Cloud reports or campaigns. Then, by sending via Email Studio Send Flow to the Salesforce data extension, the customer can leverage tracking and reporting features of Marketing Cloud Connect.
References:
https://help.salesforce.com/articleView?id=sf.mc_co_data_integration_synchronized_data_sources.htm&type=5
https://help.salesforce.com/articleView?id=sf.mc_es_send_email_send_flow.htm&type=5