Marketing-Cloud-Consultant Practice Exam Questions with Answers Salesforce Certified Marketing Cloud ConsultantSFMCExam (SP25) Certification

A filtered keyword list is a list of words or phrases that trigger an automated response when a subscriber replies with them to an email. For example, if “take me off your list” or “opt out” are added to a filtered keyword list with an unsubscribe action, any subscriber who replies with those phrases will be automatically unsubscribed from future emails. This can help NTO handle manual unsubscribe requests more efficiently and avoid sending unwanted emails to their customers. References: https://help.salesforce.com/articleView?id=sf.mc_es_reply_mail_management.htm &type=5 https://help.salesforce.com/articleView?id=sf.mc_es_create_a_filtered_keyword_list.htm &type=5

A decision split activity is a journey builder activity that allows branching the journey based on attribute values or engagement behavior of each contact. Contact data refers to data that is stored outside the journey, such as in data extensions or data views. Journey data refers to data that is captured at the moment of entry into the journey, such as from a Salesforce entry event. By using both contact and journey data in a decision split activity, NTO can compare attribute values from different sources using an attribute-to-attribute comparison. For example, they can compare the promo code from the transaction data extension (contact data) with the promo code from the entry event (journey data) and divert contacts who have redeemed the promo code before reminder emails are sent. References: https://help.salesforce.com/articleView?id=sf.mc_jb_decision_split.htm &type=5 https://help.salesforce.com/articleView?id=sf.mc_jb_attribute_to_attribute_comparison.htm &type=5

To troubleshoot why tracking details from Email Studio initiated sends are not being sent back to Sales Cloud, Northern Trail Outfitters should verify that required profile attributes are properly mapped. Required profile attributes are attributes that are needed for Marketing Cloud Connect to function properly and sync data between Marketing Cloud and Sales Cloud. These attributes include Email Address, Subscriber Key, First Name, Last Name, and Full Name. References: https://help.salesforce.com/s/articleView?id=sf.mc_co_troubleshoot_marketing_cloud_connect_configuration_issues.htm &type=5

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

To inject customers into journey B based on email engagement in journey A, Northern Trail Outfitters should use an engagement split followed by a contact activity in journey A. The engagement split can evaluate if customers opened or clicked the email in journey A. The contact activity can update a boolean field on an engagement data extension that indicates if customers are eligible for journey B. Then, an automation can run a query activity to select the customers who have the boolean field set to true and inject them into journey B. References: https://help.salesforce.com/s/articleView?id=sf.mc_jb_engagement_split.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_jb_contact_activity.htm &type=5

Querying contacts from the Einstein Engagement Frequency data extension when creating the send can be used to limit the number of emails a subscriber receives to a maximum of one email every 14 days. The Einstein Engagement Frequency data extension contains information about how often each subscriber engages with emails and what is their optimal send frequency. By filtering the data extension based on the optimal send frequency, the send can exclude subscribers who have already received an email within the last 14 days. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_data_view_einstein_engagement_frequency.htm &type=5

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 send SMS and push notifications together with emails as part of a new customer onboarding journey, Northern Trail Outfitters should use a GUID or another generated ID for Contact Key. A Contact Key is a unique identifier for each contact in Marketing Cloud across different channels and platforms. A GUID or another generated ID is recommended as a Contact Key because it is persistent, consistent, and channel-agnostic. References: https://help.salesforce.com/s/articleView?id=sf.mc_co_subscriber_key.htm &type=5

A File Drop Automation with a Verification Activity can be used to fulfill the requirement of sending an email to all contacts who have signed up for its newsletter, but have not joined its loyalty program. A File Drop Automation can be used to trigger an automation when a file is uploaded to the Marketing Cloud FTP. A Verification Activity can be used to check the number of records in the file and stop the automation if the file is empty. 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_verification_activity.htm &type=5

To send an email with 10 personalized fields from multiple data extensions to an audience of over one million subscribers, Northern Trail Outfitters should create and send to a sendable data extension containing those needed fields using a query activity. A query activity can join and filter data from multiple data extensions and populate a sendable data extension with the required fields for personalization. This will improve the email send performance and avoid timeouts or errors. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_query_activity.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_es_send_email_using_a_data_extension.htm &type=5

The number of business units that NTO needs to purchase depends on several factors, such as the number of brands or geographies they operate, the need for data or content segregation between them, and the number of Marketing Cloud users they have or plan to have. These factors affect the complexity, scalability, and cost of their account hierarchy and governance. The number of Sales Cloud sandboxes or testing/development business units are not directly related to the number of business units they need to purchase, but rather to their testing and deployment strategy. References: https://help.salesforce.com/articleView?id=sf.mc_overview_business_units.htm &type=5 https://help.salesforce.com/articleView?id=sf.mc_co_best_practices_for_creating_a_business_unit_structure.htm &type=5

A parent business unit is the top-level business unit in an account hierarchy that can share data, content, and settings with its child business units. A child business unit is a lower-level business unit that inherits data, content, and settings from its parent business unit but can also have its own data, content, and settings. By creating a parent business unit for the corporate office and a child business unit for each franchise owner, the customer can achieve data and content sharing as well as customization and segmentation for each local store. References: https://help.salesforce.com/articleView?id=sf.mc_overview_business_units.htm &type=5

To export a data file to its SFTP containing all subscribers who did not receive their intended email in the last 24 hours, Northern Trail Outfitters should use a Data Extract Activity in their automation. A Data Extract Activity is an activity that allows marketers to extract data from Marketing Cloud and place it in a file on an Enhanced FTP location or an external SFTP location. The Data Extract Activity can use different extract types, such as Tracking Extract or Data Extension Extract, to export different types of data. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_data_extract_activity.htm &type=5

Creating a new business unit for the new brand can be used to have different styles and identities for the emails and landing pages. A business unit is a logical grouping of Marketing Cloud features, settings, users, and data that allows for brand separation within an account. A business unit can have its own sender profile, delivery profile, content, domains, and SAP. References: https://help.salesforce.com/s/articleView?id=sf.mc_co_business_units.htm &type=5

Using an import activity to import a file from the SFTP can be used to maintain an auto-suppression list. An import activity allows users to import data from a file on the Marketing Cloud FTP into a data extension or list. An auto-suppression list is a type of exclusion list that prevents subscribers from receiving certain types of messages based on criteria such as email address, subscriber key, or domain. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_import_file_activity.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_es_auto_suppression_lists.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

To capture and categorize email Not Sent events and insert them into a data extension using Automation Studio, Northern Trail Outfitters should use the following order of activities:

• Data Extract with the Tracking Extract type. This activity will extract tracking data, such as Not Sent events, from Marketing Cloud and place a zipped file in the Safehouse.
• File Transfer from Safehouse. This activity will move the zipped file from the Safehouse to an Enhanced FTP location.
• File Transfer unzip. This activity will unzip the file and place it in an Enhanced FTP location.
• Import File. This activity will import the file into a data extension.

Data Extension Extract is not a valid extract type for tracking data. SQL Query is not an activity that can insert data into a data extension from a file. Data Factory Utility is not a valid activity in Automation Studio. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_data_extract_activity.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_as_file_transfer_activity.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_as_import_file_activity.htm &type=5

Keyword opt in and SMS Messaging can be used to allow attendees to request event-specific notifications by texting a keyword to a short or long code. The keyword can trigger an SMS message with the requested information or a link to a CloudPage with more details. References: https://help.salesforce.com/articleView?id=sf.mc_moc_keyword_opt_in.htm &type=5 https://help.salesforce.com/articleView?id=sf.mc_moc_sms_messaging.htm &type=5

Performing large-scale segmentation in Automation Studio before admitting contacts into Journey Builder can help reduce the amount of contacts admitted into the journey, thereby increasing the performance of the journey.

Creating prefiltered, sendable copies of data extensions for each journey instead of using the same entry source can also help optimize journey performance as it reduces the number of contacts that have to be processed for each journey. This can help with performance as the data extension is already filtered and therefore the journey has to do less work in terms of filtering the participants. For more information, see the Salesforce Certified Marketing Cloud Consultant Exam Study Guide[1] or the Salesforce documentation on Journey Performance[2].

[1] https://trailhead.salesforce.com/content/learn/certifications/marketing-cloud-consultant/marketing-cloud-consultant-exam-study-guide  [2] https://help.salesforce.com/articleView?id=mc_jb_improve_journey_performance.htm &type=5

To enable data extensions for sending SMS messages from MobileConnect, Northern Trail Outfitters should add two fields to their data extensions: a field of Locale type containing the country code and a field of Phone type containing the mobile number. These fields are required for MobileConnect to identify and send messages to mobile subscribers. References: https://help.salesforce.com/s/articleView?id=sf.mc_moc_create_a_data_extension_for_mobileconnect.htm &type=5

SSH key authentication is a method of authenticating FTP users using SSH keys instead of passwords. SSH keys are more secure than passwords because they are encrypted and do not expire or need to be changed periodically. By requesting SSH key authentication to be enabled for their FTP user and creating an SSH key in key management, NTO can upload data files to Marketing Cloud using SFTP without having to update their file transfer script on the data warehouse each time a password changes and without compromising security. References: https://help.salesforce.com/articleView?id=sf.mc_overview_enable_ssh_key_authentication_for_ftp_users.htm &type=5 https://help.salesforce.com/articleView?id=sf.mc_overview_create_an_ssh_key_in_key_m anagement.htm&type=5

To create a task on Contact and Lead records for follow up when someone has not opened five emails in a row, a scheduled automation can be used to run a SQL query activity that selects the subscribers who meet this criteria from the _Open data view and inserts them into a data extension. The data extension can then be used as an entry source for a journey that has a task activity to create the task in Sales Cloud. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_data_view_open.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_jb_task_activity.htm &type=5

A verification activity is an automation studio activity that allows checking the record count or field value of a data extension and sending a notification email if it meets certain criteria. A filter activity is an automation studio activity that allows filtering records from a source data extension into a target data extension based on filter criteria. By using these two activities in an automation, NTO can monitor available coupon codes in their coupon data extension and send a notification email to their email specialist if the available coupon count falls below 500. An import activity is used to import data from an external file or data source into a data extension, which is not relevant for this use case. A data extract activity is used to extract data from a data extension or data view into a file, which is also not relevant for this use case. References: https://help.salesforce.com/articleView?id=sf.mc_as_verification_activity.htm &type=5 https://help.salesforce.com/articleView?id=sf.mc_as_filter_activity.htm &type=5

A Sender Authentication Package (SAP) is a set of features that authenticate an email sender’s identity and reputation, such as a private domain, a dedicated IP address, a link customization, and a reply mail management. A SAP can benefit customers who send large volumes of emails (such as 500,000 per month) and want to have consistent email branding with their domain (such as sender address, links, images, etc.). A SAP can also improve deliverability and avoid spam filters by proving that the sender is legitimate and trustworthy. References: https://help.salesforce.com/articleView?id=sf.mc_es_sender_authentication_package.htm &type=5

 To simplify the sending process using Marketing Cloud with as little additional setup as possible, the customer should create a journey and use Salesforce Data and the Reports object as the entry source. This will allow them to use their existing complex reports in Sales Cloud as criteria for injecting contacts into the journey and sending them emails. References: https://help.salesforce.com/s/articleView?id=sf.mc_jb_salesforce_data_event.htm &type=5

A SQL query is an automation studio activity that allows querying data from data extensions or data views using SQL statements. A data view is a system-generated table that stores information about subscriber actions, such as clicks, opens, bounces, etc. The _Click data view contains information about each click event for each subscriber in the last six months. By creating and executing a SQL query against the _Click data view, the customer can identify all subscribers who clicked on a link within any email sent within the last six months. References: https://help.salesforce.com/articleView?id=sf.mc_as_sql_query_activity.htm &type=5 https://help.salesforce.com/articleView? id=sf.mc_as_data_view_click.htm&type=5

To encourage customers who made a purchase on their website without leaving a review to come back and review their purchase, Northern Trail Outfitters should use Google Analytics 360. Google Analytics 360 is a tool that allows marketers to measure website activity and behavior, such as purchases and reviews, and create audiences based on those metrics. These audiences can then be used as entry sources for journeys in Marketing Cloud that send targeted messages to customers. References: https://help.salesforce.com/s/articleView?id=sf.mc_co_google_analytics_360_integration_overview.htm &type=5

To target all customers who have registered to receive push notifications, Northern Trail Outfitters can use two ways to create this segment:

• Using Mobile Studio, create a Mobile Push Filtered List then filter on the MobilePush Demographics attribute group. This is a user-friendly tool that allows marketers to segment their mobile push audience based on criteria and conditions without coding.
• Using Automation Studio, query the _MobilePushDemographics Data View and save this to a data extension. This is a more advanced tool that allows marketers to segment their mobile push audience using SQL queries and data views.

Using Journey Builder or Contact Builder are not ways to create segments for mobile push audiences, as they are used for different purposes. References: https://help.salesforce.com/s/articleView?id=sf.mc_moc_create_a_filtered_list.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_as_query_activity.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_as_data_view_mobilepushdemographics.htm &type=5

To automate exclusion of identified email addresses from all future sends that use specific sender profiles, Northern Trail Outfitters should use an auto-suppression list. An auto-suppression list is a tool that allows marketers to exclude subscribers from email sends based on their email address and sender profile. The email addresses can be added to the auto-suppression list using a SQL query or an import activity. References: https://help.salesforce.com/s/articleView? id=sf.mc_es_create_an_auto_suppression_list.htm&type=5

The correct solution for this scenario involves utilizing Journey Builder with a Salesforce Data entry source. This setup allows the journey to be triggered by data changes in Salesforce CRM, such as the scheduling of an appointment. Once the journey is initiated, Journey Builder activities can be employed to send the necessary notification message to the contact. Additionally, the journey can include activities that update the CRM records, marking the "Confirmation sent" checkbox as true. This process ensures that all changes in CRM, including the creation or modification of appointment records, can initiate the journey and perform the required actions in both Marketing Cloud and Salesforce CRM. References: Salesforce Journey Builder documentation, Salesforce CRM and Marketing Cloud Integration

• 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. References: 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

To choose a subscriber key for Marketing Cloud, Northern Trail Outfitters should use a value that is unique, persistent, and channel-agnostic. A CRM ID or a loyalty program number are both good options, as they meet these criteria and can be used to identify and track subscribers across different channels and platforms. Email and mobile device ID are not good options, as they are not unique or persistent (subscribers can change their email or device) and they are specific to one channel (email or mobile). References: https://help.salesforce.com/s/articleView?id=sf.mc_co_subscriber_key.htm &type=5

To integrate a new dataset with pre-existing contacts, Northern Trail Outfitters should create a new data extension and link it to the other data extension. A data extension is a table that stores data in Marketing Cloud, such as contact information or purchase history. Data extensions can be linked by common fields or attributes using Contact Builder or SQL queries. References: https://help.salesforce.com/s/articleView?id=sf.mc_es_data_extensions.htm &type=5

To send an email with personalized fields from multiple data extensions without coding experience, Northern Trail Outfitters should combine the data outside of Marketing Cloud and upload it into a sendable data extension. This will allow them to have all the required fields for personalization in one data source and avoid using complex scripting or queries to join and filter data from multiple data extensions.

Establishing data relationships and creating data filters would not help with personalization, as they are used for segmentation purposes. Creating SQL query activities would require coding skills and experience with SQL syntax. References: https://help.salesforce.com/s/articleView?id=sf.mc_es_send_email_using_a_data_extension.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

To get real-time updates on transactional email metrics, such as Sent and Not Sent, Northern Trail Outfitters should use Event Notification Service. Event Notification Service is a feature that allows marketers to receive real-time notifications of email tracking events via webhooks or APIs. Event Notification Service can help marketers monitor and troubleshoot transactional email sends and ensure compliance with legal obligations. References: https://help.salesforce.com/s/articleView?id=sf.mc_es_event_notification_service.htm &type=5

To send an email to one million contacts in Sales Cloud using 10+ fields to segment contacts, Northern Trail Outfitters should send to a Salesforce Report from Marketing Cloud using Email Studio Send Flow. Sending to a Salesforce Report allows marketers to use existing reports in Sales Cloud as target audiences in Marketing Cloud without importing or syncing data. Using Email Studio Send Flow allows marketers to select an audience, an email message, and other options for sending an email campaign. References: https://help.salesforce.com/s/articleView?id=sf.mc_co_send_flow.htm &type=5

Transactional email send with the event notification service response can be used to send password reset emails and get real-time feedback on the delivery status. If the email is not sent, an API call can be triggered to send an SMS message instead. References: https://help.salesforce.com/articleView? id=sf.mc_es_event_notification_service.htm&type=5 https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc- apis/messageDefinitionSends.htm

To send a welcome email to contacts when a contact record is added as a campaign member to a ‘Loyalty Member’ campaign in Sales Cloud, Northern Trail Outfitters should use Salesforce Triggered Sends. Salesforce Triggered Sends are emails that are sent from Marketing Cloud in response to events or changes in Sales Cloud objects, such as contacts or campaign members. Salesforce Triggered Sends allow marketers to send timely and relevant emails based on Sales Cloud data and actions. References: https://help.salesforce.com/s/articleView?id=sf.mc_co_salesforce_triggered_sends.htm &type=5

To send emails to loyalty members based on recent activity, a contact data entry source can be used to segment the data based on attributes and filters configured in Contact Builder. This allows for more flexibility and scalability than using a data extension entry source with an applied filter. References: https://help.salesforce.com/s/articleView?id=sf.mc_jb_entry_sources.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_co_attribute_groups.htm &type=5

The key questions to ask in this scenario are about the necessity of importing such a vast amount of historical data and whether the customer's license includes the Large Data Extensions feature. Understanding the customer's need for 10 years of historical data helps assess the relevance and potential performance implications for the Marketing Cloud environment. Additionally, knowing if the customer has the Large Data Extensions feature is crucial as it affects the capability to handle the significant volume of records efficiently. References: Salesforce Marketing Cloud Data Management documentation, Large Data Extensions feature specifications