B. Contact
C. RedirectTo
Certification Aid created following AMPscript code: %%[ SET @var1 = 10 SET @var2 = 20 SET @var3 =
30 ]%% How can the three variables be summed up to evaluate to 60? Choose 1.
B
An email requires custom AMPscript to append the subscriber's zip code to a link in the email. A field
name zipcode already exist in the sending data extension. Its important Marketing Cloud tracks
subscribers who click on the link. Which two AMPscript functions should be used in the setup?
Choose
B C
B. Contact
C. RedirectTo
A sendable data extension with a text field named 'Balance' contains the value S6.96 for a particular
record. The following AMPscript statement is included in an email:
IF (Balance > 6.00) THEN
SET @Result = 'Balance is more than $6.00
ENDIF
Why would this IF statement yield unintended results?
A
A. The operands are not the same data type.
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?
C
D. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
Correct Answer is D
A developer wants to use the Marketing Cloud SOAP API to retrieve which subscribers were sent a
particular email. Which SOAP API object should be used?
C
C. SentEvent
A developer wants to trigger an SMS message to a subscriber using a form published on CloudPages.
How should the SMS message be triggered once the subscriber submits the form?
D
B. InsertData AMPscript function to add the subscriber to a MobileConnect list
A developer wants to populate a data extension with the date of the most recent click for each
subscriber. Which query would accomplish this?
C
C. SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
A developer wants to include an AMPscript if/else statement in an email to satisfy the condition "if
the subscriber's tier is not premier then display heading encouraging them to upgrade." The tier
value has already been set as variable named @level. How should the developer write this
AMPscript conditional statement?
C
D. %%=IIF @level == premier, You are a premier member" Upgrade to premier now!
The Correct answer is within asnwer C which is not formatted correctly
A developer wants to implement a newsletter registration from on NTO's website. Prior to form
submission, an email address provided by the visitor should be validated. Which option could be
used to support this scenario?
A
A. REST API, /address/v1/validateEmail route
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'?
B
Response is B. 1
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 each month in the
following way:
How should the developer use AMPscript to generate the total?
C
Correct answer is C
A developer wants to add an image to Content Builder via the API and retrieve the image's published
URL. Which method should the developer use?
A
Correct answer is D
POST to the REST API/asset/v1/content/assets: This method allows you to upload an image to Content Builder. When you use this API call, you can include the image file and its associated metadata.
FileProperties parameter: After successfully uploading the image, the API response will include a FileProperties parameter. This parameter contains important details about the file, including the published URL of the image.
A developer receives a request to integrate Marketing Cloud with a lead capture tool. The lead
capture tool will call the Marketing Cloud API to create a data extension every time a new lead form
is published. The created data extension's name should match the name of the form exactly.
Which API feature could the developer use to dynamically create these data extensions?
C
Correct answer is A.
SOAP API using Create Method and the DataExtension Object: The SOAP API in Salesforce Marketing Cloud allows you to create data extensions programmatically by using the Create method along with the DataExtension object. This method is ideal for situations where you need to dynamically create data extensions with specific names and attributes, such as when a new lead form is published.
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
A developer needs to determine why a Query Activity in an Automation has failed.
Which three scenarios could have caused this? Choose 3 answers
ADE
B. SET @total = Add(@var1, Add(@var2, @var3))
SET @total = Add(@var1, @var2, @var3)