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

To recommend a scalable business unit hierarchy for Northern Trail Outfitters and its three subsidiaries, the consultant should suggest one parent BU and three child BUs with their own Sender Authentication Packages. This will allow each subsidiary business to have their own branding, content, and subscribers, as well as access to aggregate reporting and shared subscribers from the parent BU. Each child BU should have its own Sender Authentication Package to authenticate its email sends with its own domain and branding. References: https://help.salesforce.com/s/articleView?id=sf.mc_co_business_unit_setup.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_es_sender_authentication_package.htm &type=5

To query Marketing Cloud for send data across SMS, Push, and email, Northern Trail Outfitters should use _Send Data Views. Data Views are system-generated tables that store tracking and system data for different channels and platforms in Marketing Cloud. _Send Data Views contain information about email sends, SMS sends, and push sends across different business units and accounts. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_data_view_send.htm &type=5

To fulfill the requirement that the data in the sandbox should never be mixed with data in production during testing cycles, Northern Trail Outfitters should implement two separate Marketing Cloud instances. A Marketing Cloud instance is an independent environment that contains its own data, configuration, and functionality. Having two separate instances for sandbox and production will ensure data isolation and security during testing cycles. References: https://help.salesforce.com/s/articleView?id=sf.mc_overview_marketing_cloud_instances.htm &type=5

 A File Drop Automation can be used to trigger an automation when a file is uploaded to the Marketing Cloud FTP. A SQL Query can be used to segment the audience based on the data inside the file and populate a data extension for each segment. The data extensions can then be used as entry sources for different journeys. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_define_a_triggered_automation.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_as_query_activity.htm &type=5