Salesforce Updated Marketing-Cloud-Consultant Exam Questions and Answers by erica

To inform NTO’s marketing manager if more than 1,000 records are ever imported through this automation, and prevent the sendable data extension from being updated that day, the consultant should place a Verification Activity between the import and SQL Query activity. A Verification Activity is an activity that allows marketers to verify if certain conditions are met before proceeding with the next activity in an automation. For example, a Verification Activity can check if the number of records in a data extension is above or below a specified threshold, and send an email notification or stop the automation based on the result. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_verification_activity.htm &type=5

To diagnose the issue of failed Salesforce Triggered Sends, the consultant should ensure the System User is assigned the Standard User Profile. The System User is a user account that Marketing Cloud Connect uses to communicate with Sales Cloud. The System User needs to have the Standard User Profile or a custom profile with similar permissions to enable Salesforce Triggered Sends. References: https://help.salesforce.com/s/articleView?id=sf.mc_co_troubleshoot_marketing_cloud_connect_configuration_issues.htm &type=5

To allow for long-term self-sufficiency in segmentation, Northern Trail Outfitters should use data filters. Data filters are a user-friendly tool that allows marketers to segment their data based on criteria and conditions without coding. Data filters can also be refreshed and reused for different campaigns. Attribute groups are used to link data sources in Contact Builder, not for segmentation. Publication lists are used to manage opt-in preferences, not for segmentation. Query activities require SQL knowledge and coding skills, which the marketing team lacks. References: https://help.salesforce.com/s/articleView?id=sf.mc_es_data_filters.htm &type=5

Creating an installed package in Marketing Cloud with Read and Write permissions for data extensions should be used to facilitate the functionality of upserting rows into a data extension using a REST API endpoint. An installed package is a container for one or more API integrations that provides authentication credentials and permissions for accessing Marketing Cloud resources. Read and Write permissions for data extensions allow the API integration to retrieve and modify data in data extensions. References: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/create_a_package.html https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/data-extensions.html