11.11 Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Developers Marketing-Cloud-Developer Updated Exam

Salesforce Certified Marketing Cloud Developer (SU24) Questions and Answers

Question 37

A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specificdata; however, the SQL they have written does not return any records. Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

Options:

A.

Marketing Cloud does not allow DateAdd functions in QueryActivities. They should define a specific date.

B.

Marketing Cloud _Bounce data view does not contain EmailAddress. They should join on SubscriberlD.

C.

Marketing Cloud Data Views only hold 20 days worth of data. They should narrow scope of DateAdd function.

D.

Marketing Cloud does not allow use of GETDATE function. They should define a specific date.

Question 38

A developer is creating a custom preference center and wants to log unsubscribeevents from the CloudPage. Which set of parameters should be captured and provided to the LongUnsubEvent Execute Call to ensure accurate unsubscribe information?

Options:

A.

SubscriberKey and JobID

B.

SubscriberID and BatchID

C.

EmailAddress and JobID

D.

SubscriberKey and BatchID

Question 39

A company has chosen to use the REST API for triggered sends, but they continue to get the following error during their testing: "Unable to queue Triggered Send request. There are no valid subscribers."They were informed that the SOAP API provides more information about the error, and found that their payload did not include a required data extension field.

Which element of the SOAP API response provides this level of detail?

Options:

A.

ErrorDescription

B.

OverallStatus

C.

ErrorCode

Question 40

A developer built a complex dynamic email with many data variants. Rather than create test data manually, they want to use a subset of live data to validate the dynamic aspects of the email.

Which SQL function should be used to collect a representative sample from a larger data set?

Options:

A.

HAVING

B.

OVER

C.

NTILE