Salesforce marketing-cloud-developer practice test

& Answers Salesforce Certified Marketing Cloud Developer Exam


Question 1

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.

  • A. SET @total = Sum(@var1, @var2, @var3)
  • B. SET @total = Add(@var1, Add(@var2, @var3))
  • C. SET @total = Add(@var1, @var2, @var3)
  • D. SET @total = @var1 + @var2 + @var3
Answer:

B

Discussions

Question 2

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

  • A. 2Lookup
  • B. Contact
  • C. RedirectTo
  • D. HTTPGet
Answer:

B C

Discussions

Question 3

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. The operands are not the same data type.
  • B. The comparison should use the < operator.
  • C. Balance is a protected keyword.
  • D. Double quotes should be used instead of single quotes.
Answer:

A

Discussions

Question 4

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 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
Answer:

C

Discussions

Question 5

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?

  • A. Send
  • B. ListSend
  • C. SentEvent
  • D. LinkSend
Answer:

C

Discussions

Question 6

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?

  • A. Outbound SMS template and Automation Send Method
  • B. InsertData AMPscript function to add the subscriber to a MobileConnect list
  • C. CreateSMSConservation AMPscript function
  • D. requestToken and messageContact REST API objects
Answer:

D

Discussions

Question 7

A developer wants to populate a data extension with the date of the most recent click for each
subscriber. Which query would accomplish this?

  • A. SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC
  • B. SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
  • C. SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
  • D. SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1
Answer:

C

Discussions

Question 8

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?

  • A. %%[IF @level == 'premier' THEN SET @message = You are premier member
  • B. " ENDIF IF @level == 'premier' THEN SET @message = 'Upgrade to premier now
  • C. '" ENDIF]%% %%=v(message)=%%%%=IF(@level IS 'premier', Upgrade to premier now! You are a premier member%%=IIF(@level = 'premier', 'You are a premier member!', Upgrade to premier now!
  • D. %%=IIF @level == premier, You are a premier member" Upgrade to premier now!
  • E. %%IF(@level == 'premier') THEN 'Upgrade to premier now!' ELSE 'You are a premier member' ENDIF]%%
Answer:

C

Discussions

Question 9

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. REST API, /address/v1/validateEmail route
  • B. SOAP API, Perform method with ValidationAction object
  • C. SOAP API, Describe method with EmailAddress object
  • D. REST API, /messaging/v1/domainverification route
Answer:

A

Discussions

Question 10

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 [email protected] = 3 ELSEIF
Length(@point) >4 THEN SET @value = 4 ENDIF]%% Which is the expected value of @value if x =
'Tacos'?

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

B

Discussions
To page 2