Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Pass Using Marketing-Cloud-Developer Exam Dumps

Salesforce Certified Marketing Cloud Developer (SP23) Questions and Answers

Question 33

NTO is reconsidering the requirement to have English, Spanish and French versions of their email campaigns. They request a developer to create a query which aggregates clicks grouped by language of the recipient. Language is stored in a Profile Attribute. Which two Data Views would be included in the query? Choose 2 answer

Options:

A.

_Subscribers

B.

_Subscribers

C.

_AllSubscribers

D.

_Click

Question 34

NTO wants to exclude sending an email at send time to those with a record on the 'Exclude' Data Extension. The primary key on this data extension is Subscriber Key.

How would a developer write the Exclusion Script?

Options:

A.

Lookup ('Exclude','EmailAddress','SubscriberKey',SubscriberKey)

B.

Lookup ('Exclude','SubscriberKey', 'EmailAddress', emailddr_)

C.

Rowcount (LookupRows('Exclude',SubsciberKey,_SubscriberKey) >0

D.

Rowcount (LookupRows('Exclude','SubscriberKey,_SubscriberKey) >1

Question 35

A developer is configuring a File Drop Automation and wantsto use a Filename Pattern to allow for timestamps on the file. The file name will always start with the month and day (e.g. MAY15) the file is dropped onto the SFTP site.

Which two configurations should be used for the automation to successfully start? Choose 2 answers

Options:

A.

Ends With operator

B.

%%MMMMdd%%

C.

%%Month%%%%Day%°/o

D.

Begins With operator

Question 36

A developer used LookupRowsto retrieve data when building a dynamic email.

What should be the next step before using this rowset within a FOR loop?

Options:

A.

Use Row to return a specific row of the rowset

B.

Set the rowset to a new array variable

C.

Close the delimited AMPscrlpt Code Block

D.

Use RowCount to ensure the rowset contains data