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

Passed Exam Today Marketing-Cloud-Developer

Salesforce Certified Marketing Cloud Developer (SP23) Questions and Answers

Question 13

Certification Aid uses Marketing Cloud Connect and wants to create a lead capture form on a landing page. When a customer submits the form, a Lead record should be created in Salesforce. Which scripting language can be used for this? Choose 2.

Options:

A.

AMPscript to create Salesforce record, SSJS for form handling.

B.

SSJS to create Salesforce record, AMPscript for form handling.

C.

AMPscript for whole functionality.

D.

SSJS for whole functionality.

Question 14

A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?

Options:

A.

SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC

B.

SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

C.

SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

D.

SELECT c.SubscriberKey, c.eventDate FROM_Click c WHERE c.IsUnique = 1

Question 15

Northern Trails Outfitters (NTO)has a sendable data extension with 1,500,000 contact records they want to delete.

Which step is required before deleting the contacts?

Options:

A.

Query the records into a new sendable data extension and delete it

B.

Navigate to Contact Builder and delete the dataextension

C.

Divide the records in half and delete each resulting data extension

D.

Navigate to Email Studio and delete the data extension

Question 16

A developer is querying data from the _Bounce data view and storing it in a data extension. They have found that sometimes the fields SMTPBounceReason and SMTPCode exceed the 4000-character limits for each field as specified in the DE schema. After consulting with the original requestor, it was decided that they could simply store the first 4000 characters for each of those fields.

Which SQL function could be used for this purpose?

Options:

A.

RIGHT

B.

FIRST

C.

LEFT