Salesforce Marketing-Cloud-Consultant Salesforce Certified Marketing Cloud Consultant Exam (SP23) Exam Practice Test

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: &type=5

To capture customer feedback via email and create a new case in Service Cloud if a customer indicates they are unhappy with the service they have received, Northern Trail Outfitters should use an Engagement Split to capture positive or negative responses, and a Case Activity to create a new case in Service Cloud. An Engagement Split is an activity that allows marketers to route contacts based on their engagement with email messages, such as opens or clicks. A Case Activity is an activity that allows marketers to create cases in Service Cloud based on contact attributes or journey data. References: &type=5 &type=5

 To integrate Marketing Cloud with their existing point-of-sale system in order to email purchase receipts to their customers, Northern Trail Outfitters should use MuleSoft Anypoint Platform. MuleSoft Anypoint Platform is a tool that allows marketers to connect and integrate different systems and applications using APIs and connectors. MuleSoft Anypoint Platform can help transform and map data between different formats and protocols, such as JSON and SOAP. References:

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: &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: &type=5 &type=5

To utilize a Retention Policy for a data extension that stores web behavior data, two methods are possible. One is to delete data from the data extension prior to twelve months ago, then configure a Retention Period via Contact Builder. This will allow the data extension to keep only the data from the previous twelve months and delete any older data automatically. The other method is to replace the current data extension with a new data extension configured with a Retention Period. This will create a new data extension with the same fields and settings as the old one, but with a Retention Period enabled. References: &type=5 &type=5

This personalization string is used to direct a subscriber to a web version of the email, allowing them to view the email online even if their email client does not support HTML. For more information on personalization strings, please see the documentation here:  &type=5.

The %%view_email_url%% personalization string is a system-generated link that allows subscribers to view a web page version of an email. It can be included as the href attribute in a ‘view online’ link in an email template to enable users to view the email in a browser if they have trouble viewing it in their email client. The %%view_as_webpage%% personalization string is deprecated and should not be used. The %%vawp%% personalization string is an alias for %%view_as_webpage%% and should not be used either. The %%view_online%% personalization string does not exist. References: &type=5 &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: &type=5 &type=5

To configure specific data extensions, like Product Information, that are used by several business units (BU), Northern Trail Outfitters should share data extensions from the top-level BU. Sharing data extensions from the top-level BU allows marketers to grant access to common data sources across multiple child BUs without creating local copies or duplicating data. References: &type=5

GTL (Guide Template Language) is a scripting language that allows parsing and displaying JSON or XML data within an email. GTL can be used to make API calls to external services, such as the Sunny Sky API, and display the response within the email. For example, NTO can use the HTTPGet() AMPscript function to retrieve the weather information from the Sunny Sky API as a JSON object, and then use the TreatAsContent() AMPscript function to parse and display the JSON object using GTL tags and variables. References: &type=5 &type=5 &type=5

How to determine engagement should be resolved prior to generating the audience for sending a special discount offer to engaged customers on their email list. Engagement is a measure of how subscribers interact with emails, such as opening, clicking, or converting. Different criteria can be used to define engagement, such as frequency, recency, duration, or channel preference. Determining engagement can help segment the audience and target the most relevant customers for the offer. References: &type=5 &type=5

Two best practices that should be utilized for configuring customer data for long-term cleanliness and maintainability are:

• When using an external database of record, utilize that system’s identifier as the contact key. This will ensure that contacts can be identified and tracked across different channels and platforms using a consistent and persistent value.
• Define the subscriber key as a unique value that does not relate to a specific channel. This will allow contacts to change their email or mobile device without affecting their subscriber key or losing their tracking history.

Configuring Contact Builder to automatically generate a unique subscriber key is not recommended, as it may create duplicate or inconsistent records if contacts already have an identifier in another system. Regularly merging duplicate contacts is not a best practice, but rather a remedial action that should be avoided by using proper data hygiene techniques. References: &type=5

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: &type=5 &type=5 &type=5

The Contact ID field name should be included in the report in addition to email address when using a Send Flow in Content Builder. The Contact ID is a unique identifier for each contact in Sales Cloud and Marketing Cloud. It is required for sending emails to contacts using a Send Flow. The other field names are not required for this purpose. References: &type=5 &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: &type=5

SOAP API calls updating objects and CreateSalesforceObject() AMPscript are both types of API calls that are counted against the rolling 24-hour limit in Salesforce. Login calls and bulk API calls are not counted against this limit. References:

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: &type=5 &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: &type=5 &type=5

• The Shipment object requires a Lookup to Lead or Contact1. This is because triggered sends can only be sent to Salesforce contacts, leads, or person accounts when object records are created or updated1.
• An Apex Trigger is created on the Shipment object2. This is because a trigger is Apex code that executes before or after certain operations on an object2, and it can be used to invoke the Marketing Cloud integration action that triggers the email send3.

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: &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: &type=5

To take their built audience and serve personalized content based on a field in the data extension without coding experience, Northern Trail Outfitters should use Dynamic Content Blocks. Dynamic Content Blocks are blocks that allow marketers to create personalized content based on rules and filters without coding. Dynamic Content Blocks can use subscriber attributes or behaviors from data extensions, lists, or journeys as criteria for displaying different content blocks or images. References: &type=5

To refresh the sandbox in their integrated account, Northern Trail Outfitters should perform the steps in the following order:

• Disconnect. This step will disconnect Marketing Cloud Connect from Sales Cloud and prevent data loss or errors during the refresh process.
• Refresh. This step will refresh the sandbox in Sales Cloud with new data and configuration.
• Reconnect. This step will reconnect Marketing Cloud Connect to Sales Cloud using the new sandbox credentials and settings.
• Synchronize. This step will synchronize data between Marketing Cloud and Sales Cloud using Synchronized Data Sources or Salesforce Data Entry Sources.
• Authenticate. This step will authenticate Marketing Cloud Connect users in both systems and enable full functionality of Marketing Cloud Connect.

References: &type=5

Data views are system-generated tables that store information about subscriber actions, such as sends, opens, clicks, bounces, etc. Data views can be queried using SQL statements in automation studio or query studio to retrieve email metrics for analysis and reporting purposes. Data views store data for up to six months (or longer for some tables), and can be queried as frequently as needed, such as hourly or daily. References: &type=5

To separate subscriber opt-outs of the Enterprise and children’s brands, Northern Trail Outfitters should select “Subscribers will be unsubscribed from this business unity only” in Settings for each child business unit. This will allow subscribers to unsubscribe from one brand without affecting their subscription status for another brand. References: &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: &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: &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: &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: &type=5

Two options that would prevent the customer from duplicating records when implementing a Sales Cloud instance are:

• Get existing records updated with new Keys sourced from Sales Cloud instance. This option will allow the customer to update their existing records in Marketing Cloud with new keys that match their Sales Cloud records, such as Contact ID or Lead ID. This will ensure data consistency and avoid duplication across both systems.
• Continue as normal, as Marketing Cloud Contact Models will dedupe keys by Email Address. This option will allow the customer to continue using Email Address as their primary key in Marketing Cloud, and rely on Marketing Cloud Contact Models to dedupe keys by Email Address when syncing data from Sales Cloud. This will ensure data accuracy and avoid duplication within Marketing Cloud.

Uploading CSV with Migrated Subscriber Keys to All Subscribers will not prevent duplication, as it will create new records in Marketing Cloud with different keys than the existing records. Purging the current records and carrying on with new keys sourced from Sales Cloud will result in data loss and potential compliance issues. References: &type=5 &type=5

To send an email to customers who need to reset their password on their website, Northern Trail Outfitters should use Transactional Messaging API. Transactional Messaging API is a tool that allows marketers to send transactional emails with high priority and reliability. The emails are sent as quickly as possible and can be personalized with dynamic content. The web server can receive a notification when the email is sent by using callbacks or tracking events. References: &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: &type=5 &type=5

Two options that could be recommended for localizing email content to speak to subscribers in their own language are:

• Leverage AMPscript within an email template to lookup subscriber language and personalize the email based on the value. AMPscript is a scripting language that allows marketers to perform complex tasks within messages, such as looking up data from data extensions, applying conditional logic, or displaying dynamic content based on subscriber attributes or behaviors.
• Leverage enhanced dynamic content blocks within Content Builder to create language-specific emails. Enhanced dynamic content blocks are blocks that allow marketers to create personalized content based on rules and filters without coding.

Leveraging personalization strings within the email template will not help with localization, as they are used for inserting simple subscriber attributes or system information into messages. Leveraging Content Builder to create email templates for each individual language will not be efficient or scalable, as it will require creating and maintaining multiple templates for each message. References: &type=5 &type=5

To connect relational data into their journey without overloading the entry data, Northern Trail Outfitters should use Data Designer. Data Designer is a tool that allows marketers to create attribute groups that link different data sources in Contact Builder. This way, they can access relational data in decision splits and other journey activities without having to include all the data in the entry source data extension. References: &type=5

A journey that allows re-entry after exiting can be used to have a periodic, dynamic newsletter send to a set data extension that changes from day-to-day. A journey with this setting can admit contacts into the journey multiple times as long as they meet the entry criteria. The View As Web Page link will not be broken when the audience is refreshed daily because the link is based on the Job ID and Subscriber ID, which are unique for each send. References: &type=5 &type=5

To select an audience of subscribers who have made purchases in the last 6 months, but are yet to be loyalty members, Northern Trail Outfitters should use Contact Builder Attribute Groups. Attribute Groups are collections of data extensions and data sources that are linked by common fields or attributes. Attribute Groups allow marketers to create segments and filters based on data from multiple sources, such as purchase data and loyalty data. References: &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: &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: &type=5

To send a special discount offer to engaged customers on their email list, Northern Trail Outfitters should resolve how to determine engagement prior to generating the audience. Engagement is a measure of how customers interact with emails, such as opens, clicks, or conversions. Different criteria and thresholds can be used to define engagement, such as recency, frequency, or duration of interactions. Determining engagement will help Northern Trail Outfitters segment their audience and target their offer more effectively.

What the offer will be, when to send the email, and who the offer come from are important factors for designing and delivering the email, but they are not relevant for generating the audience based on engagement. References: &type=5

Three tasks that a consultant would suggest for using Journey Builder instead of Automation Studio are:

• Building simple segmented campaigns without SQL queries. Journey Builder allows marketers to create simple segmented campaigns using filters and rules without writing SQL queries. Automation Studio requires SQL queries for creating complex segments using data extensions.
• Designing decision logic via an intuitive user interface. Journey Builder allows marketers to design decision logic using activities such as decision splits, engagement splits, or random splits via an intuitive user interface. Automation Studio requires scripting or coding for creating decision logic using activities such as script activities or verification activities.
• Setting behavior-based goals. Journey Builder allows marketers to set behavior-based goals using criteria such as email opens, clicks, conversions, or custom events. Automation Studio does not have a feature for setting behavior-based goals.

Processing zipped encrypted files containing subscriber data is a task that a consultant would suggest for using Automation Studio instead of Journey Builder, as Automation Studio has activities such as file transfer activities or import file activities that can handle zipped encrypted files. Creating customer segments from multiple data extensions is a task that a consultant would suggest for using Automation Studio instead of Journey Builder, as Automation Studio has activities such as query activities or filter activities that can create customer segments from multiple data extensions. References: &type=5 &type=5

Supporting inbound messages in each country would require additional long code implementation for MobileConnect. A long code is a standard phone number that can send and receive SMS messages. Each country has its own regulations and requirements for long codes, so a single long code cannot be used for all markets. The other functionalities do not tie to additional long code implementation. References: &type=5

A send log is a data extension that captures information about each email send, such as subscriber key, email name, subject line, and send time. It can also capture custom fields that are populated at send time, such as email address or personalized content. A send log can be used to analyze which email addresses receive which emails and when. References: &type=5

Three considerations that should be made before implementing MobileConnect are:

• Long and Short Codes are not available for all countries. Long codes are local phone numbers that can be used for sending SMS messages in some countries, while short codes are special numbers that can be used for sending SMS messages in other countries. However, not all countries have long codes or short codes available or supported by MobileConnect.
• Inbound messaging only works with local Long or Short Codes. Inbound messaging is the ability to receive SMS messages from subscribers in response to outbound messages or keywords. This feature only works with local long codes or short codes that match the country of the subscriber’s mobile number.
• Not all countries are supported by MobileConnect. MobileConnect relies on mobile operators and aggregators to deliver SMS messages to different countries, but not all countries have these services available or supported by MobileConnect.

NTO would not be charged by mobile operators directly for messages, as they would pay for message credits or bundles through Marketing Cloud billing. Opting in for messages can be done via inbound message or other methods, such as web forms or APIs. References: &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: &type=5 &type=5

To track clicks on Contact records in Salesforce, two requirements must be met:

• The subscriber key must match the ContactID field in Salesforce.
• The individual level tracking option must be selected in Marketing Cloud configuration.

If either of these requirements is not met, clicks will not show up on Contact records. References: &type=5 &type=5