Free Marketing-Cloud-Developer Exam Dumps

Question 11

A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?

A. SELECT * FROM _Open WHERE ListID = '1234'
B. SELECT * FROM _Open WHERE JobID = "1234"
C. SELECT SubscriberID FROM _Open WHERE JobID = "1234"
D. SELECT SubscriberKey FROM _Open WHERE JobID = '1234'

Correct Answer:D

Question 12

NTO uses data extensions to manage the subscriber information used for their email sends, and those sends includes calls to update records with new or different subscriber information. The developer handling these records writes some AMPscript to check and see if the data extension containing those records updated using an InsertDE() call if the record doesn't yet exist. Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?

A. The InsertDE function will always insert two rows into a data extension as part of the call
B. The InsertDE function cannot be used with name and value pairs
C. The InsertDE function comes after the system added the row as part of the email send
D. The InsertDE function cannot be used at send time

Correct Answer:C

Question 13

Certification Aid wants to include SSJS in an email message. Which code block can be used for this? Choose 2.

A. <script runat=server></script>
B. [removed][removed]
C. [removed][removed]
D. [removed][removed]

Correct Answer:AC

Question 14

NTO puts the word TEST at the beginning of the name for each test email. Which query would return the subs who were sent those emails?

A. SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
B. SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'
C. SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
D. SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName= 'TEST%'

Correct Answer:C

Question 15

A developer identified duplicate contacts and initiated a Contact Delete process for 10 million subscribers. How could the process be expedited?

A. Change the Suppression value to a larger value
B. Manually delete subscribers in All Contacts
C. Stop current delete process and delete smaller groups
D. Delete any unnecessary Sendable Data Extensions

Correct Answer:D