ExamGecko
Home Home / Salesforce / Certified Marketing Cloud Developer

Salesforce Certified Marketing Cloud Developer Practice Test - Questions Answers, Page 14

Question list
Search
Search

List of questions

Search

Related questions











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?

A.
SET @total - (@jan - 3fet - @mar @apr>
A.
SET @total - (@jan - 3fet - @mar @apr>
Answers
B.
SET @total = AZD((@jan @feb) @mar) @apr)
B.
SET @total = AZD((@jan @feb) @mar) @apr)
Answers
C.
SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))
C.
SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))
Answers
D.
SET @total = (ADD(@jan,@feb), ADD(@mar, @apr))
D.
SET @total = (ADD(@jan,@feb), ADD(@mar, @apr))
Answers
Suggested answer: C

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
A.
3
Answers
B.
1
B.
1
Answers
C.
5
C.
5
Answers
D.
4
D.
4
Answers
Suggested answer: B

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

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
A.
%%[IF @level == 'premier' THEN SET @message = You are premier member
Answers
B.
" ENDIF IF @level == 'premier' THEN SET @message = 'Upgrade to premier now
B.
" ENDIF IF @level == 'premier' THEN SET @message = 'Upgrade to premier now
Answers
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!
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!
Answers
D.
%%=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!
Answers
E.
%%IF(@level == 'premier') THEN 'Upgrade to premier now!' ELSE 'You are a premier member' ENDIF]%%
E.
%%IF(@level == 'premier') THEN 'Upgrade to premier now!' ELSE 'You are a premier member' ENDIF]%%
Answers
Suggested answer: C

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
A.
SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC
Answers
B.
SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
B.
SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
Answers
C.
SELECT c.SubscriberKey, MAX(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
Answers
D.
SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1
D.
SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1
Answers
Suggested answer: C

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
A.
Outbound SMS template and Automation Send Method
Answers
B.
InsertData AMPscript function to add the subscriber to a MobileConnect list
B.
InsertData AMPscript function to add the subscriber to a MobileConnect list
Answers
C.
CreateSMSConservation AMPscript function
C.
CreateSMSConservation AMPscript function
Answers
D.
requestToken and messageContact REST API objects
D.
requestToken and messageContact REST API objects
Answers
Suggested answer: 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?

A.
Send
A.
Send
Answers
B.
ListSend
B.
ListSend
Answers
C.
SentEvent
C.
SentEvent
Answers
D.
LinkSend
D.
LinkSend
Answers
Suggested answer: C

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
A.
SELECT TOP 1 SubscriberKey FROM Orders
Answers
B.
SELECT DISTINCT SubscriberKey FROM Orders
B.
SELECT DISTINCT SubscriberKey FROM Orders
Answers
C.
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
C.
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
Answers
D.
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
D.
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
Answers
Suggested answer: C

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

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
A.
2Lookup
Answers
B.
Contact
B.
Contact
Answers
C.
RedirectTo
C.
RedirectTo
Answers
D.
HTTPGet
D.
HTTPGet
Answers
Suggested answer: B, C
Total 197 questions
Go to page: of 20