Salesforce Certified Marketing Cloud Consultant Exam

To capture open-ended feedback via SMS and write it to a data extension, using a text-response message template with embedded AMPscript is the most suitable approach. This method allows for the dynamic handling and processing of the incoming SMS responses. The AMPscript can be programmed to parse the response and write the collected data to a specified data extension, making it an effective way to capture and store open-ended feedback. Reference: Salesforce MobileConnect documentation, AMPscript in MobileConnect

How many API calls are expected to be made at peak hourly rate? This question will help determine if they have enough API limits and bandwidth for importing large volumes of data via REST API into Marketing Cloud. The REST API has limits on how many requests can be made per hour per account based on license type and edition.

Why do they require 10 years' historical data in Marketing Cloud? This question will help determine if they have a valid business case and use case for importing large volumes of historical data into Marketing Cloud. Depending on their marketing objectives and strategies, they may not need 10 years' historical data in Marketing Cloud, which could reduce their storage needs and costs.

What time of day are the API calls made is not relevant to determining a solution for importing large volumes of data via REST API into Marketing Cloud, as it does not affect how data is imported or processed. Whether someone needs to be notified if an error happens on import is not relevant to determining a solution for importing large volumes of data via REST API into Marketing Cloud, as it does not affect how data is imported or processed. Reference: https://help.salesforce.com/s/articleView?id=sf.mc_overview_large_data_extensions.htm&type=5 https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/using_the_rest_api.htm

A consideration that should be made when building dynamic content rules is that rules should be built before uploading the respective content. Dynamic content rules are rules that define what content should be displayed based on subscriber attributes or behaviors. Dynamic content rules should be created before uploading content blocks or images into Content Builder, as they cannot be edited after content is uploaded. Reference: https://help.salesforce.com/s/articleView?id=sf.mc_ceb_dynamic_content_rules.htm&type=5

To unify the messaging and branding of communications while still allowing personalization and timing of campaigns, Northern Trail Outfitters and its subsidiaries should use Distributed Marketing. Distributed Marketing is a tool that allows marketers to create consistent and compliant messages in Marketing Cloud and distribute them to Sales Cloud or Service Cloud users for sending. Distributed Marketing allows Sales Cloud or Service Cloud users to personalize and schedule messages based on their customer interactions and preferences. Reference: https://help.salesforce.com/s/articleView?id=sf.mc_dm_distributed_marketing.htm&type=5

The best solution for NTO's campaign is to use a Multi-Step journey with a Data Extension/Automation entry source. This setup allows for the segmentation and targeting of the specific subscribers as per the campaign requirements. Subscribers who have not engaged with previous emails can be identified and targeted. The journey can be configured to monitor open or click activities, and if a subscriber interacts after three messages, they can be automatically removed from the campaign. This approach provides a dynamic and automated way to manage the campaign's lifecycle based on subscriber behavior. Reference: Salesforce Journey Builder documentation, Data Extension and Automation Studio in Marketing Cloud