Latest Certified Marketing Cloud Consultant Exam Dumps: Proven Preparation Materials for Successful Certification

1. Northern Trail Outfitters wants to integrate Marketing Cloud with its existing point-of-sale system in order in email purchase receipt to its customers. The point-of-sale data will need to be transformed to be received by the Marketing Cloud triggered send API.

What extension product should be used to accomplish this integration?

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

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

4. In which two ways can Contact Builder be used to affect data stored on a data extension? Choose 2 Answers

5. A retail company's database of record resides at a 3rd-party company that also keeps track of purchase history.

That database only updates once a day where new records can be created and merged.

The database uses an "Email ID," which is a numeric field that represents both the business unit and email address.

The company now wants to be able to send real-time Welcome emails to people (newly registered website users) who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to "Email ID" in the database.

What key issue should be addressed? Choose 3 Answers

6. What functionality is contained in Journey Builder that does NOT exist in Automation Studio?

7. Northern Trail Outfitters (NTO) is launching a new subsidiary brand, Cloud Kicks, within the next six months. Cloud Kicks anticipates sending approximately 50,000 emails per month from a child business unit. NTO will execute a large campaign announcing and associating itself with Cloud Kicks as part of the brand kickoff and is comfortable sharing digital properties with them. Cloud Kicks wants to utilize a custom sending domain, but deliverability is a primary concern.

What approach should be recommended?

8. Which statement IS correct regarding the automation tools in the Marketing Cloud? Choose 3 Answers

9. Northern Trail outfitters needs to reduce the amount of work when managing messages to customers, but cannot add any more personnel due to budget constraints. There has been an increased number of customer purchases on their website, and the team currently sends batch order confirmations.

What solution will decrease manual workloads on the team and will improve their customers' experience?

10. Customer Event:

* gather data through a tablet-based webform as part of a raffle into a data extension.

* Winner is randomly selected.

* After the event, an email should be sent to the participants to gather opt ins for marketing emails.

Define 2 things necessary:

11. Northern Trail Outfitters (NTO) wants to send out a communication to subscribers who have not made a purchase the last six months. Customer are often opted-in to more than one messaging channel. NTO would like to be able to communicate the same message across all channels.

Which flow would meet their needs?

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

13. How are Publication Lists used?

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

15. Northern Trail Outfitters is noticing a gradual decline in the percentage of conversions per emails sent in their digital marketing campaign. A new initiative is being adopted to reverse the trend

What action should be taken to increase subscriber engagement? Choose 2 Answers

16. A customer wants to send SMS messages as part of a Journey. They are concerned the messages will deploy when subscribers are asleep. If a subscriber qualifies to receive an SMS message as part of the journey between 1 a.m. and 6 a.m., the customer prefers the message to not be sent.

What solution should a consultant recommend to meet the criteria?

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

18. Northern Trail Outfitters (NTO) wants to implement a drip campaign to its highest-value outdoor sports customers. NTO is including a deep product discount and wants to limit the audience to not only its best customers, but also those customers most likely to respond.

Which three criteria should they use to create an audience for this campaign? Choose 3 Answers

19. A customer manually imports records for sending. Each record contains a warehouse ID that is shared between Marketing Cloud and a third-party system. The customer does not have developer resources, but wants to include the warehouse ID in their tracking parameters so that the third-party system can identify the subscriber.

What should a consultant recommend?

20. During discovery a consultant confirmed:

*A master audience file containing contact information and data points will be used for segmentation and imported nightly.

*The customer would like to implement a mechanism that consistently prevents sending promotional emails to subscribers who work for their top three competitors.

What feature should a consultant include in the solution?

21. A consultant is configuring Marketing Cloud Connect in Marketing Cloud. The customer requires that integrated users only have access to Sales Cloud data visible to them in their Salesforce account.

How would the consultant ensure that this requirement is met?

22. Why would a contact fail to enter a Journey Builder interaction? Choose 3 Answers

23. A marketer at Northern Trail Outfitters (NTO) wants to send important updates to customers about products they have previously purchased. The marketer has little experience with coding. Also, the information is spread across multiple data extensions and is imported nightly from NTO's e-commerce platform - Contacts, Orders, Order Items, and Products.

Which design should a consultant recommend for segmentation?

24. A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their account's Enhanced FTP on a monthly basis on the 15th day of each month, expecting the email to be deployed upon completion of the import activity. However, if the 15th of the month falls on a Saturday or Sunday, the customer will provide the file on the Friday prior to the 15th and expect the promotional email to be sent on that Friday.

Given the customer's requirements, which method should be used to automate their monthly promotional email?

25. A customer has a robust Sales Cloud org with several custom objects. Historically, they have created complex reports, referencing many custom objects, to target subscribers and exported them to another email system for deployment. With the implementation of Marketing Cloud Connect, the customer wants to simplify the sending process using Marketing Cloud with as little additional setup as possible.

What should a consultant recommend to meet this criteria?

26. A customer has several values that need to be used in the body of an email send.

* The data would be stored in a reference data extension, related on SubscriberKey

* There may be one or more records for each subscriber

* The audience is generally over 1 million subscribers

* The content is time sensitive and should be sent as quickly as possible

* The customer is not using "Catch and release" sending

* The reference data extension contains 25 columns

What method should be used

27. A marketer wants to create and edit email content, as well as generate reports and manage subscriber data.

Using the principle of least privilege, which two pre-defined roles should be assigned? Choose 2 Answers

28. A customer is starting a new children's fashion brand and wants to use a dedicated business unit within their existing Enterprise 2.0 account. They anticipate many of their current Enterprise contacts will subscribe to the children's brand, however, they want to separate subscriber opt-outs of the Enterprise and children's brands. The customer has minimal technical resources available for implementation and support.

What should a consultant recommend to meet these criteria?

29. A customer's web developer team is creating a form that will leverage a Marketing Cloud REST API endpoint to upsert rows into a data extension.

How should the consultant create an installed package in Marketing Cloud to facilitate this functionality?

30. A retail customer expanded their portfolio to include additional product lines in addition to their already popular offerings. They want to give subscribers the ability to unsubscribe via email from the specific subsections while still remaining on the main commercial communications audience. This option will be included in the footer attached to the unsubscribe URL and as an option on their subscription center.

Which model would meet the requirements?

31. The customer has these requirements for storing engagement data in their data warehouse:

* All email open and click activity must be pulled daily from the Marketing Cloud.

* Output files must meet the specific requirements for the data warehouse.

* All the activity must be provided via FTP in one file.

Which automation workflow meets the customer requirements?

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

33. Which statement is correct regarding tracking aliases? Choose 2 Answers

34. A customer would like to send a quarterly re-engagement 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.

* Use an existing Measure to build the subscriber audience for current and future sends.

* Deploy emails manually for now, but possibly automate in the future.

Which configuration is recommended for the re-engagement email send?

35. A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and other bank offerings

* Data for the campaign will be in two data extensions: Customer and New Accounts

* The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m.

* The New Accounts data is encrypted and will be placed on the FTP at 10:00 p.m.

Which automated workflow meets the customer's requirements?

36. Northern Trail Outfitters has determined they will initially deploy messaging to email and SMS channels, but also plan for social advertising. Customer data originates within their point-of-sale system which communicates to Marketing Cloud in real-time via API. They want to configure their customer data for long-term cleanliness and maintainability.

Which two best practices should be utilized? (Choose 2 Answers)

37. Northern Trail Outfitters wants to send an email to one million contacts in Sales Cloud. The criteria to segment contacts include using 10+ fields to segment.

Which process should the consultant utilize for a reliable send method?

38. Northern Trail Outfitters wants to capture dietary preferences for Contacts who have registered for an upcoming launch event. They have created a data extension of Contacts who have registered for the event and will send them an SMS message from MobileConnect asking them to reply with their dietary preference. When Contact reply to SMS message, the response message will be inserted into a data extension using AMPscript.

Which two MobileConnect templates should be used to send the SMS message and capture the responses?

39. Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to be sent on behalf of the subscriber’s account representative without segmenting the audience by sales representative.

In which two ways could this distributor-specific sender profile be configured in a Marketing Cloud account with Sender Authentication Package implemented? Choose 2 Answers

40. A customer plans to configure multiple business units (BU) to support the digital marketing efforts of five international offices.

Which reasons warrants this implementation? Choose 2 Answers.

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

42. Northern Trail Outfitters' account is configured with Multi-Org to leverage two Salesforce CRM accounts. In the Cloud Kicks business unit they want to disconnect the sandbox instance and connect the production instance.

What additional configuration changes should they make?

43. A large retail company has selected Marketing Cloud and has asked to be fully migrated from their existing platform in three weeks. They have communicated the following:

* They currently have 3 million customers.

* They email customers twice a week with no known deliverability issues.

* Their contract includes one Sender Authentication Package (SAP).

What response articulates proper IP warming? Choose 2 Answers

44. Which three statements about Send Log Data is correct?

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

46. A customer wants to perform an email send to a subset of Synchronized Data Extension referencing Sales Cloud custom object data and return tracking to Sales Cloud.

Which two approaches should the consultant recommend? Choose 2 Answers

47. If I want to introduce a new line of footwear. I am excluding anyone who does not have shoe as an attribute listed in their preference center. I plan to send the emails daily. After a short time, I notice many people updating their preferences, and less emails are going out.

What is the issue causing less emails to go out? Select one.

48. A small restaurant franchise wants to implement Marketing Cloud to support their franchise owners. The owners of franchised stores add a customized local message to the marketing campaign.

What hierarchy should be recommended?

49. As part of their brand guidelines, Northern Trail Outfitters (NTO) uses a custom brand font for all print marketing materials. NTO wants to use their custom brand font in email as well.

What is the recommended best practice for font usage in email?

50. Northern Trail Outfitters has acquired a new company and is importing customer data to Marketing Cloud. They want to ensure commercial emails are not sent to email addresses who have previously opted-out.

Which feature should they use?

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

52. Northern Trail Outfitters (NTO):

* Employs Email Specialists responsible for creating content, testing, sending emails, defining the activities for Automation Studio, and creating automations.

* Prefers not to use custom roles unless it is absolutely necessary.

* Email Specialist resides in multiple business units.

Using best practices, how should a consultant create and assign roles for NTO?

53. Northern Trail Outfitters recently upgraded their preference center to allow customers to indicate which products they are interested in and to have the ability to opt up and down in send volume. They would like to configure the Delivery Options in a Journey Builder Email Activity to take these new data points into account.

Which two options could allow them to meet the requirement? Choose 2 Answers

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

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

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

57. How do you use data designer to link the web analytics data to your subscriber data?

58. Northern Trail Outfitters maintains their primary customer identity in their ERP system but managers their customer service via Service Cloud. Customer data is updated in real-time based on changes in the ERP, and the ERP customer ID serves as the Customer Key.

They want to leverage Synchronized Data Extensions to import data about cases from Service Cloud every 15 minutes.

What consideration should be made before implementing this solution?

59. Northern Trail Outfitters has been using Marketing Cloud for one of their brands for the last year and wants to migrate another brand to their portfolio. The two brands have contrasting target groups and identities so they need the emails and landing pages to have different styles that refrain from mentioning the other brand in any way.

What should be recommended?

60. A customer wants to segment point of sale system data stored in Marketing Cloud with data from the Contact and Campaign objects in Salesforce.

Which two tools should be used? Choose 2 Answers

61. Northern Trail Outfitters and its subsidiaries use Sales Cloud and Marketing Cloud to send customers frequest email communications of new products and updates on their portfolios. They have noticed the messages and branding being sent varies greatly and would like to create a bether customer experience.

What extension product should be considered to unify the messaging and branding of these communications while still allowing personalization and timing of campaigns?

62. Northern Trail Outfitters (NTO) wants to find ways to better drive return on investment and growth via their marketing sends. They plan to centralize their analytics data to allow for a more efficient analysis of this data across all of their campaigns. NTO currently has Marketing Cloud, Sales Cloud, and a third-party warehouse service.

What product would help their use case?

63. what storage model should be used if a subscriber has more than one value for an attribute?

64. When more than one subscriber email address field is created within Contact Builder, what action tells the platform which email address to prioritize in the Email application?

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

66. Northern Trail Outfitters (NTO), a longtime Marketing Cloud customer, has decided to adopt Journey Builder to help with the execution of their marketing programs. NTO does not want to duplicate efforts within the platform and has asked if they could stop using Automation Studio Entirely.

Which three tasks would a consultant suggest for using Journey Builder instead of Automation Studio?

67. A customer wants to set up a real-time, API-driven way to be alerted when transactional messages fail to send out of Marketing Cloud. They are currently in the process of hiring a full-time developer but want an implementation in place for the developer to maintain.

What should the customer have in place to ensure this solution can be implemented?

68. What is a capability of the Import within Contact Builder? Choose 2 Answers

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

70. An online retail customer needs daily promotional email content to generate with minimal time spent on creation. Their service contract includes building a custom dynamic template for this purpose.

The customer has communicated the following:

* The email content will highlight new inventory each day.

* A small team will run both their digital marketing operations and their email program.

* A user needs to build, test, and send a daily email in less than an hour.

* Images for the emails will be hosted on their website CMS.

Which question is relevant to identify strategies for designing the custom template for the customer's daily promotional email? Choose 3 Answers

71. How do you add a contact in contact builder? Choose 2

72. Northern Trail Outfitters (NTO) wants to send an email to all Contacts who have signed up for its newsletter, but have not joined its loyalty program. NTO has created a report in Sales Cloud which it will select using a Send Flow in Content Builder.

Which field name should be included in the report in addition to email address?

73. Northern Trail Outfitters (NTO) has a requirement to create a distinction between marketing and transactional emails in terms of From Name and IP Address for reputation purposes.

Which two actions should NTO take to create Send Classifications? Choose 2 Answers

74. A customer is collecting data from a Smart Capture form that stores submissions in a data extension. The customer wants an email sent to the marketing manager each morning that contains the previous day's submissions as a CSV attachment. Assuming that the customer has the attachments feature enabled.

Which automation workflow will accomplish this?

75. 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'

76. Northern Trail Outfitters (NTO) is launching a new campaign, driving it to redesign its data structure. NTO needs to change the cardinality between two data extensions inside Contact Builder.

What are two consequences of this change? Choose 2 Answers

77. A company collects subscriptions on its websites.

It does the following:

• Compiles that subscription list in a database in the website content Management System (CMS).

• Posts this encrypted list to Marketing Cloud nightly at 11 p.m.

• Uses Marketing Cloud as the database of record.

• Sends up to five emails a week based on subscriber engagement with prior sends.

What automation sequence (excluding waits) should cover these requirements?

78. A consultant explains how a sending domain differs from a customer's primary domain. The customer is evaluating their options around configuring their domain.

Which two questions should their IT team be asked? Choose 2 Answers

79. Northern Trail Outfitters wants 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.

Which method should they use to send the email from Marketing Cloud?

80. A customer wants to display a subscriber's first name and the date of send in its monthly newsletter. Subscriber first name data is stored in a data extension that will not be used in the send definition.

Which option should be in this scenario?

81. Northern Trail Outfitters (NTO) maintains a blog for key outdoor enthusiast influencers to use in sharing their experiences with NTO equipment and the outdoors. NTO also sends out a weekly email newsletter, and they want to include links to the latest blog entries as part of the newsletter.

Which two solutions could pull in the RSS feed at the time of send? Choose 2 Answers

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

83. A customer wants to send an email from Sales Cloud on behalf of the record owner.

How should the consultant meet this requirement? Choose 2 Answers

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

85. Northern Trail Outfitters (NTO) plans on sending SMS and push notifications together with emails as part of a new customer onboarding journey.

What should a consultant recommend as a unique identifier for each subscriber?

86. Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to 5 emails per week based on subscriber activity.

The list is:

* Compiled in a database in the website Content Management System (CMS).

* Imported into Marketing Cloud nightly at 11 p.m.

What action should be taken if a third party is sending a message for the customer outside of the Marketing Cloud?

87. A company is hosting a series of events and wants its customers who register to enter into a journey.

Which two methods are viable configurations for entry? Choose 2 Answers

88. By which three standard methods could contacts be injected into a journey? Choose 3 Answers

89. An entertainment customer has added a new business unit for one of its record labels. It has also purchased a Sender Authentication Package (SAP) and owns the branded domain.

What is necessary to complete SAP setup?

90. Analyst of The Northern Trail Outfitters (NTO) marketing team needs to pull email metrics for an upcoming quarterly company meeting.

These metrics need to be reported per email campaign for each of NTO's Business Units:

* Number of Sends

* Delivery Rate

* Overall Bounce Rate

* Block Bounce Rate

* Open Rate

* Click Rate

* Complaint Rate

* Unsubscribe Rate

Which email report should NTO's Marketing Analyst pull from Marketing Cloud to get this information?

91. Northern Trail Outfitters is noticing a gradual decline in the percentage of conversions per emails sent in their digital marketing campaign. A new initiative is being adopted to reverse the trend.

What action should be taken to increase subscriber engagement? Choose 2 Answers

92. 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)

93. A customer wants to link web analytics data to subscriber data.

How should this be set up in Data Designer?

94. A retail company does business in both the United States and Canada. They have a loyalty program in which a customer can enroll. The company will provide a pre-segmented customer file, per campaign, which has a “Version” data field indicating the type of email the customer is to receive.

Which two questions should be asked to determine a data/segmentation strategy? Choose 2 Answers

95. A customer is using Marketing Cloud Connect but not sending tracking back to Sales Cloud. They want to create a Task on Contact and Lead records for follow up when someone has not opened five emails in a row.

Which activities could be used to fulfill this requirement?

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

97. Northern Trail Outfitters has purchased a new Marketing Cloud account with two dedicated IP addresses. One IP address will be used for commercial sends, while the other will be reserved for transactional messages.

Their customer base includes 1.5 million email addresses.

What should the consultant recommend?

98. NTO wants not only to send to their best customers, but also those most likely to buy.

What data will be helpful to send out an email which increases purchase frequency? Choose All that apply

99. Northern Trail Outfitters wants to encourage customers who made a purchase on their website without leaving a review to come back and review their purchase. They want to use Journey Builder to automatically inject contacts who meet these criteria into a Journey.

What product should be recommended?

100. A financial company wans to use Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week.

The company has shared the following:

* Payment.csv will arrive on the Enhanced SFTP each Monday at 1 a.m.

* Payments.csv will be encrypted.

* Payments.csv will contain data from the previous week.

* Late payment notices will be sent each Monday at noon.

* They need to receive a file containing customers who opened or clicked on the late payment notice email within five days after send.

Which automation sequence represents a viable solution?