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

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

Comment: *

Name: *

Email: *

Verification: *

A developer needs to write AMPscript to ensure the expiration date on a coupon is the last day of the month.
What would produce the desired result?

• A.Find the first day of next month and subtract one day
• B.Use the date format stringfor last day of month within FormatDate
• C.Add one month using DateAdd to now
• D.Add 30 days using DateAdd to now

Comment: *

Name: *

Email: *

Verification: *

Which activity is required before a compressed file can be imported?

• A.Import File
• B.Data Extract
• C.Decompress File
• D.File Transfer

Comment: *

Name: *

Email: *

Verification: *

A new record is appendedto the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?

• A.SELECT TOP 1 SubscriberKey FROM Orders
• B.SELECT DISTINCT SubscriberKey FROM Orders
• C.SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
• D.SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1

Comment: *

Name: *

Email: *

Verification: *

A developer is troubleshooting the cause of incomplete results in the link tracking data for an email send.
How should the RedirectTo AMPscript function be described as it relates to link tracking'

• A.It prevents link href values from getting recorded in tracking
• B.It ensures link href values containing AMPscript variables are recorded in tracking
• C.It ensures link href values containing HTML bookmarks or anchors are recorded in tracking
• D.It ensures static link href values are recorded in tracking

Comment: *

Name: *

Email: *

Verification: *