CRT-550 Exam Dumps - Salesforce Certified Marketing Cloud Consultant Exam (SU24)

Go to page:

Question # 4

How do you add a contact in contact builder?

Choose 2

Import to MyLists

Import to All Subscribers List

Import to DE

Add manually to All Subscribers

Full Access

Question # 5

A consultant wants to trigger an email whenever the status field on the Lead Object changes to Hot, Tracking data will need to be kept in the sales cloud.

Which three steps should the consultant use in the solution

Enable triggered sends on the Lead object in configuration

Write an Apex Trigger on the Lead object

Create the triggered send definition in the sales cloud

Create the triggered send definition in the marketing cloud

Put a SOAP API in place via the marketing cloud API

Full Access

Question # 6

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:

* CustomerlD

* FirstName

* EmailAddress

* OrderlD

* OrderDate

* ShippedDate

Which SQL statement should the consultant use?

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

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

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

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

Full Access

Question # 7

Tracking Alias question:

Same URL

Email Conversion Tracking

Can be found in some reports

Differentiate clicking email

Full Access

Question # 8

What is the skill set you need to build emails with dynamic content?

CSS

HTML