Salesforce Salesforce Certifications MARKETING-CLOUD-CONSULTANT Questions & Answers

• Question 111:

  A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:

  1.

  CustomerlD

  2.

  FirstName

  3.

  EmailAddress

  4.

  OrderlD

  5.

  OrderDate

  6.

  ShippedDate

  Which SQL statement should the consultant use?

  A. SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD

  B. SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD

  C. SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD

  D. SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID

  Correct Answer: D

• Question 112:

  A financial services customer wants to send email to customers who log in for the first on a new IP. This message should be deployed as fast as possible due to its sensitive content. The message contain information related to the login IP.

  What should a consultant recommend to deploy the email?

  A. Inject the subscriber into a Journey.

  B. Use the Transactional Messaging API.

  C. Execute a Triggered Emails Interaction.

  D. Use a User-Initiated Emails Interaction.

  Correct Answer: B

• Question 113:

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

  What could be causing this?

  A. The associated Contact should be updated to be injected

  B. Synchronized Data Sources poll for changes every 15 minutes at the quickest

  C. Orders are not being updated from not meeting criteria to meeting criteria

  D. Orders should be set up to allow injection upon update in Connect Configuration

  Correct Answer: C

• Question 114:

  A customer will provide a single daily file on the Marketing Cloud SFTP at 3 a.m. and needs an alert if the file is NOT present on time. The file needs to be:

  1.

  Imported iota a staging data extension.

  2.

  Separated into two different data extensions.

  Which automation should meet these requirements?

  A. Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

  B. File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

  C. Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

  D. File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

  Correct Answer: B

• Question 115:

  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?

  A. A Transactional Journey with the Not Sent Notification activity included

  B. A Datorama instance to ingest their data

  C. An external system to receive and confirm callback and subscriptions

  D. An Interaction Studio instance to ingest their data

  Correct Answer: C

• Question 116:

  Northern Trail Outfitters' marketing team is new to Marketing Cloud and has very little coding experience. They have employed a consultant to help them design an automated solution for maintaining an auto-suppression list.

  Which solution should the consultant recommend?

  A. Use Einstein Segment Recommendations

  B. Use an import activity to import a file from the SFTP

  C. Use a query activity to populate the auto-suppression

  D. Use the Import Wizard in Automation Studio

  Correct Answer: C

• Question 117:

  Northern Trail Outfitters received an email about reaching API limits within Salesforce and they think this is caused by the integrated Marketing Cloud account.

  Which two types of API calls are counted against the rolling 24-hour limit?

  A. SOAP API Calls updating objects

  B. CreateSalesforceObject() AMPscript

  C. Login Calls

  D. Bulk API

  Correct Answer: AD

• Question 118:

  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?

  A. Create a scheduled Automation with a Query Activity and a Send Email Activity

  B. Use Content Builder Send Flow to send the email to the Salesforce Campaign

  C. Create a Journey with a Salesforce Campaign entry source and an Email Activity

  D. Create a Journey with a Salesforce Data entry source and an Email Activity

  Correct Answer: C

• Question 119:

  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?

  A. One-to-Many Relationship

  B. Many-to-Many Relationship

  C. One-to-One Relationship

  D. Population

  Correct Answer: C

• Question 120:

  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?

  A. Journey Data queried from main data extension

  B. Contact Data Mapped through Salesforce Marketing Cloud Profile Attributes

  C. Journey Data using CRM Report Import Activity to Salesforce Data Extension

  D. Contact Data using Synchronized Data Sources

  Correct Answer: D