ExamGecko
Login
Ask Question

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

List of questions

Question 131

Report
Export
Collapse

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?

SET @total - (@jan - 3fet - @mar @apr>
SET @total - (@jan - 3fet - @mar @apr>
SET @total = AZD((@jan @feb) @mar) @apr)
SET @total = AZD((@jan @feb) @mar) @apr)
SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))
SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))
SET @total = (ADD(@jan,@feb), ADD(@mar, @apr))
SET @total = (ADD(@jan,@feb), ADD(@mar, @apr))
Suggested answer: C
asked 23/09/2024
safiqueahmed kazi
37 questions

Question 132

Report
Export
Collapse

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'?

3
3
1
1
5
5
4
4
Suggested answer: B
asked 23/09/2024
Kaliannan K
33 questions

Question 133

Report
Export
Collapse

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?

REST API, /address/v1/validateEmail route
REST API, /address/v1/validateEmail route
SOAP API, Perform method with ValidationAction object
SOAP API, Perform method with ValidationAction object
SOAP API, Describe method with EmailAddress object
SOAP API, Describe method with EmailAddress object
REST API, /messaging/v1/domainverification route
REST API, /messaging/v1/domainverification route
Suggested answer: A
asked 23/09/2024
Liam Derwin
41 questions

Question 134

Report
Export
Collapse

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?

%%[IF @level == 'premier' THEN SET @message = You are premier member
%%[IF @level == 'premier' THEN SET @message = You are premier member
" ENDIF IF @level == 'premier' THEN SET @message = 'Upgrade to premier now
" ENDIF IF @level == 'premier' THEN SET @message = 'Upgrade to premier now
'" 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!
'" 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!
%%=IIF @level == premier, You are a premier member" Upgrade to premier now!
%%=IIF @level == premier, You are a premier member" Upgrade to premier now!
%%IF(@level == 'premier') THEN 'Upgrade to premier now!' ELSE 'You are a premier member' ENDIF]%%
%%IF(@level == 'premier') THEN 'Upgrade to premier now!' ELSE 'You are a premier member' ENDIF]%%
Suggested answer: C
asked 23/09/2024
Fatmata Kabba
51 questions

Question 135

Report
Export
Collapse

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

SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC
SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC
SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1
SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1
Suggested answer: C
asked 23/09/2024
MARCIA SHEILA PELAEZ GONZALEZ
38 questions

Question 136

Report
Export
Collapse

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?

Outbound SMS template and Automation Send Method
Outbound SMS template and Automation Send Method
InsertData AMPscript function to add the subscriber to a MobileConnect list
InsertData AMPscript function to add the subscriber to a MobileConnect list
CreateSMSConservation AMPscript function
CreateSMSConservation AMPscript function
requestToken and messageContact REST API objects
requestToken and messageContact REST API objects
Suggested answer: D
asked 23/09/2024
Kurt Woodfin
43 questions

Question 137

Report
Export
Collapse

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?

Send
Send
ListSend
ListSend
SentEvent
SentEvent
LinkSend
LinkSend
Suggested answer: C
asked 23/09/2024
Web Administrator
43 questions

Question 138

Report
Export
Collapse

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?

SELECT TOP 1 SubscriberKey FROM Orders
SELECT TOP 1 SubscriberKey FROM Orders
SELECT DISTINCT SubscriberKey FROM Orders
SELECT DISTINCT SubscriberKey FROM Orders
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
Suggested answer: C
asked 23/09/2024
Said Jabri
40 questions

Question 139

Report
Export
Collapse

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?

The operands are not the same data type.
The operands are not the same data type.
The comparison should use the < operator.
The comparison should use the < operator.
Balance is a protected keyword.
Balance is a protected keyword.
Double quotes should be used instead of single quotes.
Double quotes should be used instead of single quotes.
Suggested answer: D
asked 23/09/2024
Tania Trif
50 questions

Question 140

Report
Export
Collapse

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

2Lookup
2Lookup
Contact
Contact
RedirectTo
RedirectTo
HTTPGet
HTTPGet
Suggested answer: B, C
asked 23/09/2024
Nivenl Surnder
33 questions
Total 197 questions
Go to page: of 20
Search
Open VPLUS File
Convert VPLUS to PDF

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 developer needs to push real-time updates of the company's product catalog to a data extension. Which two API options are available? Choose 2 answers
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 developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV. Which SQL functions could be used to change each line break to a single space?
Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields are visible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.
A developer is configuring a new Marketing Cloud account and has decided to use a unique 10-digit integer as each customer's Contact Key. Which data type should be used when representing the value of Contact Key?
A developer is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each. Which application utilizes the REST API?
A customer wants a list of subscribers who were sent an email within the past 12 months. How should this request be completed?
Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels. What should be recommended5
A company needs to retrieve a large number of rows from a data extension via the API. Which two solutions would optimize the performance? Choose 2 answers