Updated Salesforce Certified Marketing Cloud Consultant Dumps – Practice All Questions and Answers Regularly

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

2. Northern Trail Outfitters (NTO) is the holding company of three subsidiaries: Universal Containers, Ursa Major Solar, and Cloud Kicks. NTO recently purchased Marketing Cloud and has asked its consultant to recommend a scalable business unit (BU) hierarchy. They don't plan on executing any marketing campaigns on behalf of the NTO holding company, but NTO employees would like access to all subscribers and aggregate reporting. Additionally, each subsidiary business will be regularly running campaigns and should have their own branding, content, and subscribers.

Which solution should the consultant recommend?

3. A B2B customer has customized journeys they want to use for several key accounts they are trying to sell into.

How could Marketing Cloud Connect be used to initiate these sends when contacts for select accounts are created?

4. Nothern Trail Outfitters wants to enable Sales Cloud users to manually create a segment of both lead and contact records that can be targeted through the Send Flow in Content Builder.

What should a consultant recommend for segmentation?

5. Northern Trail Outfitters uses separate Marketing Cloud accounts as environments for development, UAT, and production. They want to test all automations and Journeys In each environment prior to launching in production.

Which extension product should be used to speed up the migration of data extensions and Journey Builder configurations between each environment?

6. Northern Trail Outfitters (NTO) send emails from Content Builder and Journey Builder. When subscribers reply to an email, NTO would like to send an auto-reply message using a pre-defined HTML email that explains email replies are unmonitored and they should call NTO for any inquiries.

How could these auto-reply messages be enabled?

7. Northern Trail Outfitters wants to target all customers who have registered to receive Push Notifications. Their app uses the Mobile Push SDK.

In which two ways should this segment be created?

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

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

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

11. A customer wants to capture and categorize email Not Sent events and begin identifying trends. They want to keep the data in Marketing Cloud and run queries against the dataset. The customer created a data extension to receive the information.

Which order of Automation Studio activities should be recommended?

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

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

14. Northern Trail Outfitters (NTO) wants to use Marketing Cloud to .. customer feedback. If a customer indicates they are unhappy with the service they have received, NTO wants a new case to be created in service Cloud. NTO is unsure of what is possible within Marketing Cloud but would like to use as much native functionality as possible.

What approach would a consultant recommend?

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

16. Northern Trail Outfitters has several business units (BU) and each BU uses specific data extensions, like Product Information.

How Should they configure these data sources?

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

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

19. Northern Trail Outfitters injects outcomes journey B based upon email engagement in journey A.

Which method would facilitate this solution?

20. A school corporation uses one contact per parent/child combination, updating the email address based on who they are sending to. However, they would tike to pull data on which email addresses receive which emails.

What functionality could be used to accomplish this?

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

22. A consultant configured a triggered send definition in Sales Cloud for a customer using Marketing Cloud Connect, The trigger is on a Custom Object called 'Shipments' and is enabled for Triggered Sends in Setup.

Which two configuration requirements should be considered when troubleshooting? (Choose 2 answers)

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

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

25. Northern Trail Outfitters (NTO) has been storing web behavior to a data extension for several years. They have indicated with several hundred millions of rows there has been an impact on performance. NTO indicates they only need to store data from the previous twelve months which will not exceed eighty million rows.

Which two methods would allow them to utilize a Retention Policy? (Choose 2 answers)

26. Northern Trail Outfitters has a data extension that stores all of their orders. They want to send out a dally email for orders with their status changed to 'shipped' that day through a journey.

Which two methods should be used to filter entry into the journey? Choose 2 answers

27. Northern Trail Outfitters wants to send a weekly coupon campaign. They segment their audience using data from several data extensions, which results in an audience size of approximately 200,000 subscribers. They want to send a reminder three days later at the subscribers' optimized send time.

What solution should they use?

28. 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 Marketing Cloud.

What is the implication of this data model when using Marketing Cloud Connect?

29. Northern Trail Outfitters wants to provide near real-time data in a 30-day welcome journey.

Which data setup should they use for decision splits?

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

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

32. Northern Trail Outfitters wants to implement a Welcome email. New subscribers signing up on their website should receive the email promptly. They are utilizing Marketing Cloud Connect to connect Sales Cloud and Marketing Cloud.

Which solution should capture the new subscribers?

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

34. Northern Trail Outfitters wants to send an email to website visitors who add items to their cart but fail to make a purchase.

The email will include a list of products they added to their shopping cart.

• A sendable data extension contains the contact information and a session ID field for each subscriber who has abandoned their cart.

• A second data extension contains a corresponding session ID field and product data for each abandoned cart item, including product SKU, product name, quantity, price, and image URL.

Which feature should be used to display the list of products for each subscriber in this email?

35. Northern Trail Outfitters continually adds rows for subscribers to a data extension via API, populating subscribers who should receive a monthly payment reminder that day. They want to use Journey Builder to send the payment reminder emails.

What would be required to process the correct subscribers?

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

37. An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and Not Sent, to ensure they are fulfilling a legal obligation due to the nature of their messages.

38. Northern Trail Outfitters' marketing team is made up of a marketing manager, a marketing specialist, and a graphic designer. The team is new to Marketing Cloud and has very little coding experience. Currently, they use Excel and VLOOKUP to segment their email audiences and import them into Marketing Cloud.

What solution should be recommended to allow for long-term self-sufficiency in segmentation?

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

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

41. A customer wants to limit the number of emails a subscriber receives to a maximum of one email every 14 days. After the 14-day period, the subscriber is eligible to receive the next message.

What should a consultant recommend to meet this criteria?

42. Northern Trail Outfitters (NTO) uses the SAP domain comms.nto.com and has just opened an office in Australia. They have created a business unit for their new office and want to use the domain comms.nto.com.au to send emails to their Australian customers.

What would be required to enable sending emails from their new domain without impacting deliverability?

43. Northern Trail Outfitters in interested in a solution to automate a process. They currently pull data into a spreadsheet to import into a extension for sending. The data warehouse can be configured to place a file daily on an SFTP.

Which three questions are relevant to determining a solution? Choose 3 answers

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

45. Northern Trail Outfitters uses a Salesforce Data Entry Source in their Journey that injects Salesforce Order when they are either create update with a status of New, Currently Knitting, Shipped, and Complete. Their Journey works when orders are created, but they noticed it does not injected customers when their status is updated.

What could be causing this?

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

47. Northern Trail Outfitters (NTO) is saving each Email Address in its SendLog which is quickly increasing in size. NTO's marketers want to pull data from the SendLog for troubleshooting based on email address when a subscriber either does not receive an email or receives the wrong email.

Which design should the consultant recommend to perform their analysis?

48. Northern Trail Outfitters receives a nightly encrypted unsub file to their Marketing Cloud SFTP from a third-party email platform. These files are used to unsubscribe existing subscribers. They do not use Email Address as Subscriber Key.

What Automation Studio Activity sequence should be used to ensure the appropriate subscribers are unsubscribed from the All Subscriber List?

49. Northern Trail Outfitters wants to export a data file to its SFTP using Automation Studio. The file should contain all subscribers who did not receive their intended email in the last 24 hours. The automation will be scheduled to run each day.

Which activity Is required in the automation?

50. Northern Trail Outfitters has started the process of integrating its Marketing Cloud account and Sales Cloud org through Marketing Cloud Connect.

Which configuration should be utilized for the API user created in Marketing Cloud?