A customer wants to create a mobile app that requires users to log in or register before accessing their dat a. Their source of truth is Sales Cloud which is connected to Marketing Cloud. Users who log in with existing credentials will have their device associated with their ContactKey. Users who register with the mobile app will not have their devices associated with a ContactKey for up to 24 hours.What consideration should a consultant provide to the customer?

Newly registered users will create additional Contacts in Marketing Cloud.

All mobile app users will create additional Contacts in Marketing Cloud.

User device data is unavailable in Contact Builder for up to 24 hours.

Existing users will create additional Contacts in Marketing Cloud.

Newly registered users will create additional Contacts in Marketing Cloud.

Northern Trail Outfitters has integrated their Marketing Cloud account with their Salesforce sandbox.In what order should the steps be performed to refresh the sandbox in their integrated account?

Disconnect / Refresh / Reconnect / Authenticate / Synchronize

Refresh / Disconnect / Reconnect / Synchronize / Authenticate

Disconnect / Refresh / Reconnect / Synchronize / Authenticate

Refresh / Disconnect / Reconnect / Authenticate / Synchronize

Northern Trail Outfitters wants to have a periodic, dynamic newsletter send to a set data extension, but the data in this data extension will be regularly updated and the subscribers inside could be removed/added multiple times.What option should speed up the delivery while meeting these criteria?

Scheduled Automation using a Send Activity

Journey that allows re-entry after exiting

Scheduled Automation utilizing Triggered Send Emails

Scheduled Automation using a Send Activity

Northern Trail Outfitters is sending to an audience of over one million subscribers. They will use 10 different personalized fields in the email which reside in multiple data extensions. The goal is a timely email send from start to finish as it contains a limited quantity, first come-first served, special offer.How should they accomplish this task?

Use the Lookup AMPscript function in the email to pull the fields from the data extensions for each subscriber.

Create and populate profile attributes for each of the 10 data extension fields and schedule a send with high priority.

Enable Send Throttling on high to ensure the speed Is increased to process the email as fast as possible.

Use the Lookup AMPscript function in the email to pull the fields from the data extensions for each subscriber.

Create and send to a sendable data extension containing those needed fields using a query activity.

Northern Trail Outfitters (NTO) wants to create a relevant audience from a data extension for a daily send campaign. The audience will change from day-to-day. These emails contain a View As Web Page link and NTO wants to ensure this will not be broken when the audience is refreshed daily.What should be used to segment this audience?

Use AMPscript inside the email to pull information from a send logging data extension to determine which content displays based on message context

Use exclusion lists for the send - excluding those that already were sent the email

Use AMPscript inside the email to pull information from a send logging data extension to determine which content displays based on message context

Use a SQL Query to filter the audience into a new data extension that is overwritten each day

Use SQL Query to filter the audience into a new data extension that is upserted every day

Northern Trail Outfitters noticed that clicks are NOT showing up on Contact records in Salesforce.Which two reasons could be the cause?Choose 2 answers

Email Address was used as Subscriber Key

Individual Level Tracking was not selected in Marketing Cloud Configuration

Synchronized Data Sources only push data every 15 minutes

ContactID was used as Subscriber Key

Email Address was used as Subscriber Key

Individual Level Tracking was not selected in Marketing Cloud Configuration

Northern Trail Outfitters is sending email messages using Marketing Cloud Connect through the Sales Cloud user interface. All of their sends initiated from Sales Cloud have a status of failed.What should the consultant do to diagnose the issue?

Initiate a log to troubleshoot package-related API calls.

Change the connection option to Scope by User.

Ensure the System User is assigned the Standard User Profile.

Manually clear the OAuth token to refresh the connection.

A real estate agency wants to send out a biweekly newsletter with the list of properties for all new contacts added to a newsletter campaign in their Salesforce CRM. The journey consists of an initial message with property listings and a follow up to those who have engaged with the content.The rules around which properties are matched to the contact depend on agent assigned as a contact owner, other agents who might have interacted with the contact, and contact's property interest. The data model has a relationship between contact > person account > real estate agent > property objects and all of those are available in CRM as well as synchronized to Marketing Cloud.What solution should be recommended for execution efficiency?

Use Salesforce Data Event to initiate journey and scripting within emails for personalization logic.

Use Automation Studio and Salesforce sends with campaign as an audience.

Use Automation Studio to prepare personalization data and initiate journey.

Use Salesforce Data Event to initiate journey and scripting within emails for personalization logic.

Use send from Salesforce CRM and Salesforce report to prepare personalization data.

Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE).• The first DE is populated by web analytics data, and does not contain a Subscriber Key or Email Address value.• A Customer Reference DE is updated daily and holds subscriber information.• The third DE is populated by a file sent to the SFTP after five days If the customer has not purchased the abandoned items.• The third DE will be used in the journey for a decision split, and it does not contain a Subscriber Key or Email Address.• If the web analytics file is empty, NTO does not want the automation to finish running.Which order of activities should be used to fulfill this requirement?

File Drop Automation > Import File Activity > Verification Activity > Query Activity for file one > Query Activity for file two > Data Extension Entry

Scheduled Automation > Import File Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two

File Drop Automation > Import File Activity > Verification Activity > Query Activity for file one > Query Activity for file two > Data Extension Entry

File Drop Automation > Verification Activity > Query Activity for file one > Data Extension Entry > Query Activity for file two

Scheduled Automation > Import File Activity > Verification Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two

ABC Company wants to automate the sending of shipping notices and a customer survey.• Shipping notices will be sent once a day.• The shipping file will be placed on the FTP some time after 4:00 p.m.• The shipping data will be sorted in the Shipping Notice data extension.• A field in the data extension will contain the shipping date.• The survey needs to be sent at 9:00 a.m., exactly 10 days after the customer's order ships.Which workflow would most effectively enable ABC Company to do this?

Automation 1: Triggered Import File -> Filter -> Send Email -> Wait-> Filter -> Send Email

Automation 1: Scheduled to run daily at 7:00 PM Import File -> Filter -> Send Email -> Wait -> Filter-> Send Email

Automation 1: Scheduled to run daily at 7:00 PM Automation 2: Scheduled to run daily at 9:00 AM Import File -> Filter -> Send Email -> Filter -> Send Email

Automation 1: Triggered Automation 2: Scheduled to run daily at 9:00 AM Import File -> Filter -> Send Email -> Filter -> Send Email

A customer has been having problems with SMS responses getting the default keyword response rather than the appropriate next keyword response.What are two potential reasons for this unexpected response?Choose 2 answers

Responses are not sent within 24 hours of the outbound message.

Next keyword was not specified on the outbound message.

Responses are not sent within 24 hours of the outbound message.

Response contained "stop" in the message content.

Responses are not sent within the Conversation Window.

Next keyword was not specified on the outbound message.

A customer has curated a list of known email addresses belonging to competitors. They want to ensure none of these competitors receive their emails.What should a consultant recommend'

Create an auto-suppression list populated with the known email addresses.

Create an auto-suppression list populated with subscriber keys.

Populate a list using a query to exclude the subscriber key.

Create an exclusion list with the known email addresses.

Create an auto-suppression list populated with the known email addresses.

A customer indicates their point-of-sale system can be configured to upload a file every fifteen minutes. The filename is not consistent for each upload. Their consultant recommends they use a File Drop Automation.Which two considerations should be made?Choose 2 answers

The directory Is unable to be used by another File Drop Automation.

The directory used by the file trigger should be inside the import directory.

They may utilize an external FTP site.

The directory Is unable to be used by another File Drop Automation.

The directory used by the file trigger should be inside the import directory.

The directory cannot contain more than five file triggers.

Northern Trail Outfitters wants to automate a weekly SMS message to be sent to anyone who has a birthday that week. They have created the Outbound Message in MobileConnect and have a Filtered List created for every contact who provided birth date information.Which activities would Marketing Cloud use to automate this campaign?

Refresh Mobile Filtered List and Send SMS

Refresh Mobile Filtered List and Outbound Send

Import Mobile Contacts and Outbound Send

Refresh Mobile Filtered List and Send SMS

Import Mobile Contacts and Send SMS

Northern Trail Outfitters is growing and acquiring other organizations, each with its own instance of Sales Cloud. They are debating whether to upgrade Marketing Cloud Connect to Multi-Org.What consideration could be provided to help with the decision?

Once an account is upgraded to Multi-Org, it cannot be turned off.

Shared Salesforce Data Extensions will be enabled in up to 5 business units.

Custom profile and subscription centers will not be required.

Once an account is upgraded to Multi-Org, it cannot be turned off.

Existing accounts cannot be upgraded to Multi-Org.

Northern Trail Outfitters is migrating from a legacy emailing tool to Marketing Cloud. As part of the migration, they have to go through a security review. Their data privacy team has made it clear that the data in the sandbox should never be mixed with data In production during testing cycles.What recommendation would a consultant provide on the architecture to fulfill this requirement?

Implement two separate Marketing Cloud instances.

Ensure test sends are done from data extensions with attribute 'Is Testing1.

Create one or more additional business units for testing.

Use Subscriber Filter per business unit to filter production from test data.

A customer wants to integrate a new dataset with pre-existing contacts. This data will be updated via separate data feeds from the main contact information.What data model configuration should be recommended'

Create a new data extension and link it to the other data extensions.

Create additional attribute fields in the main contact data extension.

Create new Salesforce data extension and link it to the other data extensions.

Create a new data extension and link it to the other data extensions.

Create a new data extension and link It as a new population.

Northern Trail Outfitters is investigating implementing MobileConnect to allow SMS messaging in their UK, Germany, and Swiss subsidiaries. Each subsidiary has its own business unit and they are trying to determine if a single long code could be used for all markets.What functionality would tie to additional long code Implementation?

Do they need to support inbound messages in each country?

Do they need to support UTF-8 characters in their SMS?

Do they need to support different From Names by country?

Do they need to have independent reporting on SMS sends by country?

Do they need to support inbound messages in each country?

Northern Trail Outfitters wants to set up an automation that imports a file and sends an email to the contacts when the file is dropped on the SFTP. The name of the file will change, though it will always start with thankyou_customers.How would they set up the Import Activity to know the name of the file?

Set File Naming Pattern to %%BASEFILENAME_FROM_TRIGGER%%

Set File Naming Pattern to %%AUTOMATED_FILENAME%%

Set File Naming Pattern to %%BASEFILENAME_FROM_TRIGGER%%

Filename is automatically passed to Import Activity with File Drop Automations

Check the 'Use filename from Automation' checkbox

A customer asks why the send time values within an email are not being added to a Send Log.Which two actions would successfully write send time variables to their Send Log? Choose 2 answers

Match an AMPscript variable name to a Send Log field.

Enable send logging to a data extension during send process.

Match an AMPscript variable name to a Send Log field.

Use the WriteToLogO AMPscript function In the content.

Ensure the send log Is linked In an attribute group.

Enable send logging to a data extension during send process.

Northern Trail Outfitters is using a Salesforce entry event in a Journey to send SMS to contacts located in the United States. They notice new SMS contacts are not receiving messages, and the mobile number in the Salesforce Entry Data Extension was missing the country code.How could they resolve this issue?

Format the phone field in Salesforce as +l[phonenumber],

Select 'Normalize Phone Number* in Journey settings.

Format the phone field in Salesforce as +l[phonenumber],

Select 'US' as the sending country in SMS activity.

Configure the phone field in Salesforce as US locale.

Northern Trail Outfitters wants to include the body of marketing email replies captured by Reply Mail Management (RMM) within auto-forwarded messages to their Customer Success team.How could they accomplish this?

Use RMM personalization strings to render the email reply body.

Check the Include Replies as Attachments'' box in the RMM settings.

Use RMM dynamic content blocks to render the email reply body.

Query the RMM data view for the reply body and reference it from a data extension.

Use RMM personalization strings to render the email reply body.

Northern Trail Outfitters is interested in a solution to automate a process. They currently pull data into a spreadsheet to import into a data extension for sending. The data warehouse can be configured to place a dally on an SFTP.Which three questions are relevant to determining a solution?Choose 3 answers

Does someone need to be notified if an error happens on import?

Will the data file be placed on the SFTP at the same time daily?

Is the data file a delta or a historical file?

Does the data extension have a data relationship?

Does someone need to be notified if an error happens on import?

Will the data file be placed on the SFTP at the same time daily?

Will the file have more than 5,000 rows?

Is the data file a delta or a historical file?

A customer wants to create a loyalty program by Identifying all subscribers who clicked on a link within any email sent within the last six months.What should be recommended?

Create and execute a SQL Query against the _Click data view.

Create and execute a Tracking Extract.

Create and execute a Subscriber Engagement report.

Create and execute a Data Filter on the_Click data view.

Northern Trail Outfitters has created child business units (BU) for their different regional offices. They want to limit subscriber records by BU, so users who are assigned to a BU can only view and send to Subscriber records in their region. A Profile Attribute named 'Region' associates a subscriber to a geographical region.How could they ensure subscribers with a matching 'Region' Profile Attribute value are available in each BU?

Select 'Define Subscriber Filter' for each BU on the BU Setup page and configure a condition to match the corresponding Profile Attribute.

Create a list in each BU and add subscribers with a matching Region to the list.

Create a measure for each corresponding 'Region' Profile Attribute and include the measure in a Filtered Data Extension for each BU.

Open the the Profile Attribute Properties for the Region' Profile Attribute and select the 'Filter Subscribers by Attribute' option.

Select 'Define Subscriber Filter' for each BU on the BU Setup page and configure a condition to match the corresponding Profile Attribute.

Northern Trail Outfitters sends emails for Password Resets from their web store when requested. An SMS message should be deployed if the password reset email is not sent.What processes should they utilize to ensure a timely delivery across email and SMS?

Transactional email send with the event notification service response to determine and trigger an API call to an SMS message

Triggered send definition and use data extract Not Sent to a data extension then send SMS to those failed sends

Multiple path journey with engagement split if password reset link clicked; if link not clicked, then SMS Password Reset activity

Triggered send definition, and use API response to determine and send API call to trigger an SMS password reset

Transactional email send with the event notification service response to determine and trigger an API call to an SMS message

Northern Trail Outfitters (NTO) is creating a birthday journey and one of the requirements is to divert anyone who has redeemed the promotional code before reminder emails are sent on the 15th and 20th of each month. Their transactional information, which includes redeemed promo codes, Is housed in a separate data extension than the one used for Journey injection. NTO needs to use an attribute to attribute comparison on the customer number field in the Journey source and transaction data extensions.Which activity would they use to accomplish this?

Decision Split Activity using both Contact and Journey Data

Decision Split Activity using only Contact Data

Decision Split Activity using only Journey Data

Decision Split Activity using both Contact and Journey Data

A customer is connecting Sales Cloud with Marketing Cloud. The connection was successful, however, the team is unable to view or sync Sales Cloud objects in Contact Builder.How should a consultant begin troubleshooting the connection?

Validate Marketing Cloud and Sales Cloud permissions for the connecting users.

Create and send an email in Email Studio to test the connection and validate tracking.

Validate Marketing Cloud and Sales Cloud users have access to the business unit.

Create new Marketing Cloud and Sales Cloud users and perform a new installation.

Validate Marketing Cloud and Sales Cloud permissions for the connecting users.

A customer wants to use Sales Cloud as a system of record for email messages sent from Marketing Cloud; however, the customer only sends from custom objects and cannot use the Contact ID or Lead ID as the Contact Key in MarketingCloud.What is the implication of this data model when using Marketing Cloud Connect?

Email Sends will fail if the Contact ID or Lead ID is not included.

Tracking Data will not be returned to the Sales Cloud email recipient.

The customer will be able to use Reports and Campaigns as audiences.

The customer will be unable to use synchronized data extensions.

Salesforce Certified Marketing Cloud Consultant Practice Test 7

Northern Trail Outfitters (NTO) wants to send using the From Address of [email protected].

They will then automatically forward replies to [email protected]. NTO also wants to include an automatic reply to the customer's email address [email protected].

Which email address would appear as the From Address for the automatic reply to the customer?

Become a Premium Member for full access

Unlock Premium Member

Salesforce Certified Marketing Cloud Consultant Practice Test 7

Question

Salesforce Certified Marketing Cloud Consultant Practice Tests

Practice Tests