Salesforce Certified Marketing Cloud Developer Practice Test - Questions Answers, Page 14
List of questions
Question 131
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Question 132
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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'?
Question 133
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Question 134
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Question 135
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?
Question 136
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Question 137
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Question 138
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Question 139
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Question 140
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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
Question