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

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_a s_query_activity.htm&type=5https://help.salesforce.com/s/articleView?id=sf.mc_es_send_email_using_a_data_extension.htm &type=5

The email address that would appear as the From Address for the automatic reply to the customer isreply@marketingcloud.com. This is because Northern Trail Outfitters has configured their Reply Mail Management settings to forward replies to customerservice@nto.com and send an auto-reply message to the customer’s email address. The From Address for theauto-reply message is always reply@marketingcloud.com, regardless of the original From Address or the forwarding address. References:https://help.salesforce.com/s/articleView?id=sf.mc_es_reply_mail_management.htm &type=5

To ensure there’s a limit to the number of times a particular image asset can be chosen for a customer, NorthernTrail Outfitters should set fatigue rules for the product asset classes. Fatigue rules are settings that allow marketers to control how often an asset can be selected for a customer within a specified time period. For example, a fatigue rule can prevent anasset from being selected more than once in 14 days. References:https://help.salesforce.com/s/articleView?id=sf.mc_ceb_einstein_co ntent_selection_fatigue_rules.htm&type=5

To automate a weekly SMS message to contacts who have a birthday that week, the Refresh Mobile Filtered List activity can be used to update the filtered list based on the birth date criteria. The Outbound Send activity can then be used to send the SMS message to the contacts in the filtered list. References: https://help.salesforce.com/s/articleView?id=sf.mc_moc_refresh_mobile_filtered_list.htm &type=5https://help.salesforce.com/s/articleView?id=sf.mc_moc_outbound_send.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 onattributes 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=5https://help.salesforce.com/s/articleView?id=sf.mc_co_attribute_groups.htm &type=5

A journey with CRM date based entry source can be used to trigger emails based on a date field in the CRM object, such asthe reminder date. The journey can also use the Update Contact activity to update the record in CRM after sending the reminder email. References: https://help.salesforce.com/articleView?id=sf.mc_jb_date_based_events.htm &type=5https://help.salesforce.com/articleView?id=sf.mc_jb_update_contact.htm &type=5

To queryMarketing 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 DataViews 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

Two options that would prevent the customer from duplicatingrecords 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 SalesCloud 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: https://help.salesforce.com/s/articleView?id=sf.mc_co_subscriber_key.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_co_contact_key.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. By having an additional SAP for the new domain comms.nto.com.au, NTO can send emails from their new domain without impacting deliverability. An additional IP address is not required if they already have one for their SAP. An additional private domain is not enough to authenticate their sender identity and reputation. Registering the new domain in From Address Management is not necessary if they have an SAP for the new domain. References: https://help.salesforce.com/articleView?id=sf.mc_es_sender_authentication_package.htm &type=5https://help.salesforce.com/articleView?id=sf.mc_es_from_address_management.htm &type=5

By using Tracking Extract, File Transfer, and Import activities from Automation Studio, you can extract the data from the subscribers who have had emailsfail due to held status within the last 60 days [1][2], and then transfer the data into a data extension that can be used as an Entry Source for Journey Builder. This will allow you to create an SMS message that can be sent to the subscribers to ask them to update their email address. Additionally, Automation Studio provides the ability to schedule and automate the process so that the data is regularly updated and the SMS message is sent on a regular basis. For further information, please refer to the following Salesforce documentation:

• Automation Studio Overview: https://help.salesforce.com/articleView?id=mc_as_overview.htm &type=5 • Automation Studio Activities: https://help.salesforce.com/articleView?id=mc_as_activities.htm &type=5 • Data Extensions Overview: https://help.salesforce.com/articleView?id=mc_es_data_extensions.htm &type=5 • Journey Builder Overview: https://help.salesforce.com/articleView?id=mc_jb_overview.ht m&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:https://help.salesforce.com/s/articleView?id=sf.mc_cab_attribute_groups.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 useDistributedMarketing. 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. References:https://help.salesforce.com/s/ articleView?id=sf.mc_dm_distributed_marketing.htm&type=5

Publication List and Auto-Suppression List can be used to control what content is available to certain users and business units based on their preferences and send volume. A Publication List allows subscribers to opt in or out of different types of communications, while an Auto-Suppression List automatically excludes subscribers from receiving certain messages based on criteria such as frequency or content category. References: https://help.salesforce.co m/articleView?id=sf.mc_es_publication_lists.htm&type=5https://help.salesforce.com/articleView?id=sf.mc_es_auto_suppression_lists.htm &type=5

To send SMS messages to contacts located in the United States using a Salesforce entry event in a journey, NTO should format the phone field in Salesforce as +l[phonenumber], where +1 is the country code for the United States and [phonenumber] is the 10-digit phone number without any spaces or dashes. Thisformat ensures that Marketing Cloud can correctly identify and validate the mobile numbers for SMS sending. Normalizing phone numbers in journey settings only applies to mobile numbers stored in MobileConnect or MobilePush demographics tables, not to mobile numbers from Salesforce entry events. Selecting ‘US’ as the sending country in SMS activity only affects how opt-out keywords are processed, not how mobile numbers are validated. Configuringthe phone field in Salesforce as US locale only affects how phone numbers are displayed in Salesforce, not how they are formatted for Marketing Cloud. References: https://help.salesforce.com/articleView?id=sf.mc_rn_june_2020_moc_normalize_phone_number_journey_setting.htm &type=5 https://help.salesforce.com/articleView? id=sf.mc_moc_country_code_processing_for_opt_out_keywords.htm&type=5https://help.salesforce.com/articleView?id=admin_phoneformat.htm &type=5

Three questions that are relevant todetermining a solution for automating a process of importing data from a data warehouse into Marketing Cloud are:

• Is the data file a delta or a historical file? This question will help determine how to handle existing records and avoid duplication or overwrite. A delta file contains only new or updated records, while a historical file contains all records regardless of changes.
• Will the data file be placed on the SFTP at the same time daily? This question will help determine how to schedule an automation ortrigger an event based on file drop. If the data file is placed on the SFTP at different times, then a File Drop Automation may be more suitable than a Scheduled Automation.
• Does someone need to be notified if an error happens on import? This question will help determine how to handle errors and exceptions during import. If someone needs to be notified, then an email notification activity or a verification activity may be added to the automation.

Whether the data extension has a data relationship or not isnot relevant to determining a solution for importing data, as it is only used for creating relationships between data extensions in Email Studio. Whether the file has more than 5,000 rows or not is not relevant to determining a solution for importing data, as it does not affect how data is imported or processed. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_file_drop_automation_studio_triggers.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_as_import_file_activity.htm &type=5

 Import File activity can be used to import the unsub file from the SFTP to a data extension. Query activity can be used to query the data extension and update the status of the subscribers in All Subscribers list to Unsubscribed. Data Extract and File Transfer activities are not needed for this process. References: https://help.salesforce.com/articleView?id=sf.mc_as_import_file_activity.htm &type=5https://help.salesforce.com/articleView?id=sf.mc_as_query_activity.htm &type=5

To provide near real-time data in a 30-day welcome journey, Northern Trail Outfitters should use contact data using synchronized data sources. This will allow them to access the most up-to-date data from their CRM system in decision splits and other journey activities. Journey data is static and based on the entry source data extension, whichmay not reflect recent changes in CRM. Contact data mapped through profile attributes or imported from CRM reports may not be as timely or accurate as synchronized data sources. References: https://help.salesforce.com/s/articleView?id=sf.mc_co_synchronize d_data_sources.htm&type=5https://help.salesforce.com/s/articleView?id=sf.mc_jb_decision_split.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, anddata 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

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

An auto-suppression list populated with theknown email addresses can be used to ensure none of these competitors receive their emails. 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/articleView?id=sf.mc_es_auto_suppression_lists.htm &type=5

To import new contacts gathered from an external web form at high frequency into Marketing Cloud, Northern Trail Outfitters should perform a daily bulk export to SFTP for import via automation. This will allow them to batch the contactsinto one file per day and import them into Marketing Cloud using an automation that runs at a scheduled time. References:https://help.salesforce.com/s/articl eView?id=sf.mc_as_import_activity.htm&type=5

Two potential reasons for SMS responses getting the default keyword response rather than the appropriate next keyword response are:

• Responses are not sent within the Conversation Window. The Conversation Window is a setting that defines how long MobileConnect waits for a response from a subscriber after sending an outbound message. If a subscriber responds after the Conversation Window expires, MobileConnect treats their response as a new inbound message rather than part of an ongoing conversation.
• Next keyword was not specified on the outbound message. The Next Keyword is a setting that defines what keyword MobileConnect expects from a subscriber after sending an outbound message. If a subscriber responds with a different keyword than what MobileConnect expects, MobileConnect treats their response as a new inbound message rather than part of an ongoing conversation.

Responses containing “stop” in the message content will not get the default keyword response, but rather an opt-out confirmation message. Responses sent with AMPscript in body will not affect how MobileConnect handles responses, as AMPscript isonly evaluated at send time. References: https://help.salesforce.com/s/articleView?id=sf.mc_moc_conversation_window.htm &type=5 https://help.salesforce.com/s/articleView?id=sf.mc_moc_next_keyword.htm &type=5

To format the JSON payload from their commerceplatform within the email, Northern Trail Outfitters should use the BuildRowSetFromJSON() AMPscript function. The BuildRowSetFromJSON() AMPscript function is a function that allows marketers to parse a JSON string and return a rowset object that can be used to display data within an email message. The BuildRowSetFromJSON() AMPscript function can handle nested JSON objects and arrays. References:https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/buildrowsetfromjson.htm

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

Three considerations that should bemade 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 forsending 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 relieson 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 formessage 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: https://help.salesforce.com/s/articleView?id=sf.mc_moc_mobileconnect_overview.htm &type=5

To send a series of welcome messages on behalf of the brand with an optimized send time to new customers who are sent to Marketing Cloud via an hourly batch file drop, Northern Trail Outfitters should use Automation Studio to process and segment the new customers, and use Journey Builder for the campaign sends and decisioning. Automation Studio is a tool that allows marketers to automate tasks and workflows using different activities, such as importing files, filtering data, or sending emails. Journey Builder is a tool that allows marketers to create personalized customer experiences across different channels and platforms using different activities, such as sending emails, updating data, or optimizing send time. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_automation_studio.htm &type=5https://hel p.salesforce.com/s/articleView?id=sf.mc_jb_journey_builder.htm&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 extensionwith 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: https://help.salesforce.com/s/articleView?id=sf.mc_co_da ta_retention_policies.htm&type=5https://help.salesforce.com/s/articleView?id=sf.mc_co_create_a_new_data_extension _from_an_existing_data_extension.htm&type=5

Setting up Approval Workflow andShare setting inside Marketing Cloud can be used to control what content is available to certain users and business units, what is allowed to be edited, and ensure those edits are reviewed prior to being changed. Approval Workflow allows users to submit content for approval before it can be used in messages or journeys, while Share setting allows users to share content across business units with different levels of access. References: https://help.salesforce.com/articleView?id=sf.mc_co_approval_workflow.htm &type=5https://help.salesforce.com/articleView?id=sf.mc_co_share_content_across_business_units.htm &type=5

An entry source filter is a filter that can be applied to an entry source injourney builder to limit which contacts are injected into a journey based on criteria such as field values or record types. A decision split is a journey builder activity that allows branching the journey based on attribute values or engagement behavior ofeach contact. By using an entry source filter on their order data extension, NTO can filter contacts whose status has changed to ‘shipped’ that day and inject them into their journey. By using a decision split within their journey, they can further segment contacts based on other criteria such as purchase amount or product category. References: https://help.salesforce.com/articleView?id=sf.mc_jb_entry_source_filter.htm &type=5https://help.salesforce.com/articleView?id=sf.mc_jb_decision_split.htm &type=5

To sendan SMS message and capture the responses in a data extension using AMPscript, Northern Trail Outfitters should use two MobileConnect templates: Text Response and Data Capture. Text Response is a template that allows marketers to send a text message to a mobile number and receivea reply. Data Capture is a template that allows marketers to use AMPscript to insert the reply into a data extension. References: https://help.salesforce.com/s/articleView?id=sf.mc_moc_text_response.htm &type=5https://help.salesforce.com/s/articleView?id=sf.mc_moc_data_capture.htm &type=5

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=5https://help.s alesforce.com/articleView?id=sf.mc_es_create_a_filtered_keyword_list.htm&type=5

Two solutions that could pull in the RSS feed at the time of send forNorthern Trail Outfitters’ weekly email newsletter are:

• AMPscript. AMPscript is a scripting language that can be used to retrieve and display dynamic content from external sources, such as RSS feeds, in emails.
• External Content. External Content is a feature that allows marketers to create blocks of content from external sources, such as RSS feeds, in Content Builder.

Dynamic Content is not a solution for pulling in RSS feeds, as it is used to display different content based on subscriber attributes or rules. Personalization Strings are not a solution for pulling in RSS feeds, as they are used to display subscriber or account information in emails. References: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/ampscriptUseCasesRetrieveRSSFeed.htm https://help.salesforce.com/s/articleView?id=sf.mc_ceb_external_content_blocks.htm &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:https://help.salesforce.com/s/articleView?id=sf.mc_moc_long_codes.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 andsender 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

A SenderAuthentication 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 as500,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 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:https://help.salesforce.com/s/articleView?id=sf.mc_ceb_dynamic_content_blocks.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

 A File Drop Automation can be used to trigger anautomation 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=5https://help.salesforce.com/s/article View?id=sf.mc_as_query_activity.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=5https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc- apis/messageDefinitionSends.htm