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.Use the date format string for last day of month within FormatDate
• B.Add one month using DateAdd to now
• C.Add 30 days using DateAdd to now
• D.Find the first day of next month and subtract one day

Comment: *

Name: *

Email: *

Verification: *

A developer initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted.
Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

• A.The suppression status does not show for individual contacts until the entire batch processes.
• B.Up to one million records can be deleted in each batch.
• C.The deletion process supersedes other automated account activities.
• D.To more quickly remove contact information, use the suppression period length of 14.

Comment: *

Name: *

Email: *

Verification: *

A new record is appended to 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 SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
• B.SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
• C.SELECT DISTINCT SubscriberKey FROM Orders
• D.SELECT TOP 1 SubscriberKey FROM Orders

Comment: *

Name: *

Email: *

Verification: *

A developer wants to create a CloudPage which is linked from an email. %%[SET @point = RequestParameter(x) SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point)>2 THEN SET @value = 2 ELSEIF Length(@point) >3 THEN SET@value = 3 ELSEIF Length(@point) >4 THEN SET @value = 4 ENDIF]%% Which is the expected value of @value if x = 'Tacos'?

• A.3
• B.5
• C.4
• D.1

Comment: *

Name: *

Email: *

Verification: *

A developer wants to transform the date and time 'Data_Enrolled' from Daylight Savings time. How would the developer change the time to fall back one hour?

• A.%%=DataAdd(Date_Enrolled,-1)=%%
• B.%%=DateDiff(Date_Enrolled, 1, 'H')=%%
• C.%%=DateAdd(Date_Enrolled,-1 'H')=%%
• D.%%=FormatDate(Date_Enrolled,-1,'HH','en-us')=%%

Comment: *

Name: *

Email: *

Verification: *