[Jul 20, 2024] Free Salesforce Marketing Cloud Consultant Marketing-Cloud-Consultant Official Cert Guide PDF Download [Q30-Q53]

Q30. Northern Trail Outfitters wants to create a query to populate a data extension with email subscribers who belong to a specific publication list.
Which Data View could they use to achieve this?

_ListSubscribers

_Subscribers

_PublicationSubscriber

_EnterpriseAttribute

Q31. Northern Trail Outfitters wants to use Marketing Cloud to send notifications to customers when their orders are ready for in-store pickup. The notifications can be either SMS or email depending on their communications preference.
How should the consultant set this up?

Create an Outbound Message in MobileConnect with AMPscript in body to trigger an email confirmation as a fallback.

Journey Builder Transactional Send Journey.

Automation with a Send SMS and Send Email activity in separate consecutive steps.

Journey Builder multi-step journey with an API entry event and a decision split.

Q32. A customer wants to send a quarterly reengagement email to subscribers who have NOT opened in the previous three months. The customer’s plans are to:
*Use an existing Paste HTML email for the first send.
*Make only minor changes to the email creative for future sends.
*Send to the subscriber list.
*Deploy emails manually for now, but possibly automate in the future.
Which send method should be used?

Guided Send

Triggered Send

Send Flow Activity

Send Email Activity

Q33. Northern Trail Outfitters recently purchased Marketing Cloud to start running cross-channel campaigns. They are looking for guidance on which value to use as the subscriber key.
Which two options should the consultant recommend? (Choose 2 answers)

Email

CRM ID

Mobile Device ID

Loyalty Program Number

Q34. An analytics team wants to get hourly updates on email metrics (send, open, click) to provide timely next best actions to the sales team.
What method should the team use?

Send Logs

Data views

Tracking Extracts

Scheduled Reports

Q35. Northern Trail Outfitters (NTO) uses Marketing Cloud to connect with its individual consumers, retailers and wholesale buyers, and its corporate apparel customers. Marketing Cloud is currently configured with data extensions containing Store, Order, Product, and Contact information. NTO is in the process of implementing Data Designer and linking its data extensions.
How should consumers, retailers, and wholesale buyers be defined in Data Designer?

Many-to-Many Relationship

One-to-One Relationship

Population

One-to-Many Relationship

Q36. Northern Trail Outfitters wants to send special discount offer to engaged customers on their email list.
What should be resolved prior to generating the audience?

What the offer will be

When to send the email

Who the offer come from

How to determine engagement

Q37. When Northern Trail Outfitters acquires a new customer, it would like to send a series of welcome messages on behalf of the brand with an optimized send time. New customers will be sent to Marketing Cloud via an hourly batch file drop.
Which solution should the consultant recommend?

Use Journey Builder to process and segment the new customers, and for the campaign sends and decisioning.

Use Automation Studio to process and segment the new customers, and use Journey Builder for the campaign sends and decisioning.

Use Automation Studio to process and segment the new customers, and use Email Studio for the campaign sends and decisioning.

Use Automation Studio to process and segment the new customers, and for the campaign sends and decisioning.

Q38. A publishing company presented the following: A need to send renewal reminders to customers whose subscribers expire in 7 days and 15 days. A campaign needs to created and managed by a general marketing user who will not have administrative rights and who is not technical. The customer’s expiration data is included in the data filter.
Which three components should the customer’s solution include?

Data Filter

Template Based emails

Suppression List

Automation Studio

Triggered Send

Q39. 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?

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.

Q40. Northern Tril Outfitters wants to connect relational data into their Journey without overloading the entry data.
How should they connect the data?

Entry Source Data Extension

Data Relationships

Data Designer

Contact Configuration

Q41. An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and NotSent, to ensure they are fulfilling a legal obligation due to the nature of their messages.
What method should be suggested in this scenario?

Platform Events API

Data View Export with every send

Data Retrieves on the Send Object

Event Notification Service

Q42. Northern Trail Outfitters sends a monthly loyalty balance email to inform members of their current points balance. Emails are segmented based on loyalty status, and no segment should contain more than 2500 contacts for any send.
What should be used to prevent emails from being sent if they exceed 2500 contacts7

Verification Activity

Script Activity

Query Activity

Stop Activity

Q43. A customer wants to perform an email send to a subset of a Synchronized Data Extension filtered on custom object data and return tracking to the Sales Cloud.
What approach should the consultant recommend?
Choose 2 answers

Use Data Stream to sync Sales Cloud objects to the Marketing Cloud.

Use Data Filters or Query Activities to output a Sendable Salesforce Data Extension.

Use Query Activities to create a Sendable Synchronized Data Extension.

Use Data Filters to segment data to output a Sendable Data Extension

Q44. A pharmaceutical company is hosting a monthly event and will be sending an invitation to new local contacts. The customer would like to automatically update a data extension to determine who will be attending.
*The data extension will hold each contact’s response as well as the time stamp of the click.
*The contact will receive an email two days after the click event.
*Both emails should be sent via Journey Builder.
What is the optimal solution to record the click activity prior to sending the second email?

Use a landing page to record the click and trigger an email.

Leverage the Decision Split and create a Custom Activity.

Leverage the Engagement Split and the Update Contact Activity.

Use a landing page to record the click in the data extension.

Q45. Northern Trail Outfitters has a customer login page on their website and wants to use Marketing Cloud to send an email to customers who need to reset their password. The email needs to be sent as quickly as possible.
Their web server should receive a notification when the email is sent.
Which solution should they use?

Triggered Send Definition

Transactional Messaging API

Multi-Step journey with an API Event entry source

Single Send journey with an API Event entry source

Q46. Every day at 3 a.m., Northern Trail Outfitter’ (NTO) data lake instance starts generating a file that contains all records that should be sent one email or another for the next day’s marketing campaigns. The size of the file varies depending on the previous day’s tracking activity. As soon as the file is generated, NTO wants to import the data, segment the data, and then execute the daily sends.
What end-to-end process should deliver this efficiently?

Scheduled Automation > File Transfer > Import > Series of Query Activities

Triggered Automation > Import Activity > Series of Query Activities > Series of Sends

Scheduled Automation > Import Activity > Series of Query Activities > Series of Sends

Triggered Automation> Import > Data Extension Extract > Marketing Journey

Q47. A user in the MC wants to use salesforce custom object data for segmenting and personalization.
How should the consultant approach this requirement?

Export report data from the sales cloud and import into a marketing cloud synchronized data extension.
Use a filter activity to produce a sendable data extension. Create an email send activity in Automation Studio

Sync contact and custom objects with Data Stream and send from Synchronized Data Extension with Salesforce email send. Ensure there is a lookup relationship to a contact or lead record.

Create a custom report type that contains the contact or lead ID, email address, and custom object data, then from the marketing cloud, import into a Salesforce Data extension. Use AMPScript in the email to call data

Map the custom objects to the profile center and use the email editor to insert the custom data. Create a user-initiated send to associate the email to the largest audience and return tracking data.

Q48. A customer wants to perform an email send to a subset of a Synchronized Data Extension referencing Sales Cloud custom object data and return tracking to Sales Cloud.
What approaches should the consultant recommend? (Choose two.)

Use SQL Query Activities to create a Sendable Synchronized Data Extension.

Use Synchronized Data Sources to sync Sales Cloud objects to Marketing Cloud.

Use SQL Query Activities to output a Sendable Salesforce Data Extension.

Use Data Filters to segment data to output a Sendable Data Extension.

Q49. Northern Trail Outfitters injects customers into journey B based upon email engagement in journey A.
Which method would facilitate this solution?

In journey A, engagement split afteremail send. In Automation studio, query JourneyActivity data new for the Engagement split result Boolean field, Use result Data

In Automation Studio, query activity engagement on Journey System data view for email send to journey A; Use result data extension for journey B Subjects.

In Automation Studio, use verification activity to verify engagement on email in journey A’ Query engagement data extension for journey B Subjects.

In journey A engagement split followed by Contact Activity to Boolean on an engagement data extension; Query engagement data extension injections.

Q50. A university plans to use Journey Builder to improve their 1:1 marketing to potential students, current students, and alumni. The university currently has student data in the Sales Cloud. Other data, such as course catalog, student demographics, and alumni information, is stored in external systems.
Which two actions should the Consultant recommend? (Choose two.)

Use Data Designer to link student and alumni data to the contact record.

Use Synchronized Data Sources to obtain data from the Sales Cloud.

Create an Import Activity to import alumni data into Salesforce Report.

Create list attributes to store student data from the Sales Cloud.

Q51. Northern Trail Outfitters wants to import their Sales Cloud data into Marketing Cloud to leverage it within Journey Builder. They have approximately 10 million customers and the data needs to be available with a delay of no more than 30 minutes. Only customers where the consent checkbox is selected in Sales Cloud should be imported, which represents approximately half of their customer database
What should they implement?

All Subscribers, since these are synchronized in real time

Import from Salesforce Report in Automation Studio

Event Data from the Entry Event in Journey Builder

Synchronized Data Extensions with a filter

Q52. Northern Trail Outfitters wants to include a ‘view online’ link in an email template to enable users to view a web page version of the email.
Which personalization string should they include as the href attribute in the link?

%%view_as_webpage%%

%%view_email_url%%

%%vawp%%

%%view_online%%

Q53. 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.