March Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

CRT-550 Exam Dumps - Salesforce Certified Marketing Cloud Consultant Exam

Question # 4

How do you add a contact in contact builder?

Choose 2

A.

Import to MyLists

B.

Import to All Subscribers List

C.

Import to DE

D.

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

A.

Enable triggered sends on the Lead object in configuration

B.

Write an Apex Trigger on the Lead object

C.

Create the triggered send definition in the sales cloud

D.

Create the triggered send definition in the marketing cloud

E.

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?

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

Full Access
Question # 7

Tracking Alias question:

A.

Same URL

B.

Email Conversion Tracking

C.

Can be found in some reports

D.

Differentiate clicking email

Full Access
Question # 8

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

A.

CSS

B.

HTML

C.

Ampscript

D.

SSJS

Full Access
Question # 9

Northern Trail Outfitters (NTO) wants to better understand subscriber behavior on their website upon arrival via an email message. A local member of a Marketing Cloud user group mentioned the Web Analytics Connector.

Which benefit is offered by installing the Web Analytics Connector in a Marketing Cloud account?

Choose 3 answers

A.

Use the web analytics platform to trigger behavioral remarketing emails.

B.

Track web activity from a click on an email URL back to a specific email campaign.

C.

Pass web conversion data back into Marketing Cloud for use in email reporting.

D.

Recognize web traffic as originating from email instead of another channel.

E.

Match subscribers to web activity by passing Subscriber ID through email links.

Full Access
Question # 10

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

A.

IP ramp-up takes four to six weeks to be able to fully send to all 3 million customers.

B.

IP ramp-up can be accelerated by migrating to pre-warmed IP addresses.

C.

IP ramp-up is important to establish a positive sender reputation.

D.

IP ramp-up can be bypassed, given their historical lack of deliverability issues.

Full Access
Question # 11

A customer has an eCommerce site and Imports data into three data extensions daily; 'Orders', 'Order_Details' and 'Products'

the data extension contains the following information:

* Orders: OrderId, CustomerId, OrderNumber, OrderDate, OrderTotal, GrandTotal

* Order_Details: ProductId, OrderId, Qty, UnitPrice, ExtendedPrice, Discount

* Products: ProductId, SKU, Name, Description, Cost, Price

What two actions should be taken in Data Designer?

A.

Create a one-to-one relationship between Orders and order_Details

B.

Create a one-to-one relationship between the contact record and Order_Details

C.

Create a one-to-one relationship between Order_Details and Products

D.

Create a one-to-many relationship between Orders and Order_Details

Full Access
Question # 12

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

A.

AMPScript a single LookupOrderRows function

B.

Dynamic content via the Dynamic content wizard

C.

Server side JavaScript a single LookupOrderedRows function

D.

AMPScript a single lookup function

Full Access
Question # 13

A customer needs to import data from an SFTP site. The customer wants to:

* Segment the contents of the file and then send emails.

* Transfer the file to the SFTP site at various times daily.

* Send to data extensions.

Which workflow should meet these requirements?

A.

Triggered Automation: Import File > SQL Query(s) > Send Email(s)

B.

Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s)

C.

Scheduled Automation: Import File > SQL Query(s) > Send Email(s)

D.

Triggered Automation: Import File > Group Refresh > Send Email(s)

Full Access
Question # 14

To fuel their expansion, Northern Trail Outfitters (NTO) recently acquired Eagle Outfitters (EO). There is currently a 30 percent overlap between the guests of each brand and they will be pursuing cross-marketing opportunities. It was recommended that their Marketing Cloud account now include a separate business unit for EO and the company secure a new sender authentication package for EO using the private domain e-EO.com.

Select the statement that correctly describes the implication of this recommendation.

Choose 2 answers

A.

The IP address included in the sender authentication package will have the same reputation as the ones being used for NTO.

B.

The EO business unit can also have the NTO authentication package applied simultaneously for cross-marketing emails.

C.

The private domain, e-EO.com, will be used for all link wrapping, image URLs, and landing page URLs.

D.

The e-EO.com domain will act as the from address for the emails and authenticate using SPF, SenderlD, and DKIM authentication.

E.

The email headers for EO will still reflect the private domain for NTO since that is the parent company.

Full Access