Big Cyber Monday Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Salesforce Developers MCE-Dev-201 New Questions

Page: 15 / 15
Total 194 questions

Salesforce Certified Marketing Cloud Engagement Developer Questions and Answers

Question 57

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

Options:

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'

Question 58

A developer wants to aggregate monthly energy usage data over a four month period for each subscriber within an email. The monthly usage values are stored in variables for eachmonth in the following way:

How should the developer use AMPscript to generate the total?

Options:

A.

SET @total - (@jan - 3fet - @mar @apr>

B.

SET @total = AZD((@jan @feb) @mar) @apr)

C.

SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))

D.

SET @total = (ADD(@jan,@feb), ADD(@mar, @apr))

Page: 15 / 15
Total 194 questions