Certified Marketing Cloud Developer

Certified Marketing Cloud Developer practice questions, page 5 of 6, with answer review and explanations.

Question 21

An UpdateDE AMPscript function is used to update a column value in a data extension row when an email is sent. The email is being sent to 250,000 subscribers, but the user decides to cancel the send during the sending process and only 400 emails are sent. How many subscriber rows would be affected by the UpdateDE function?

  1. 400 subscribers who were sent the email
  2. No rows are updated
  3. Only subscribers who exist in All Subscriber

Question 22

An email requires custom AMPscript to append the subscriber's zip code to a link in the email. A field named zipcode already exists in the sending data extension. It is important Marketing Cloud tracks subscribers who click on the link. Which two AMPscript functions should be used in the setup?

  1. Concat / RedirectTo
  2. Concat / Lookup
  3. Concat / HTTPGet

Question 23

How should a developer optimize a query activity if it is currently timing out?

  1. Use intermediate tables to stage data
  2. Use intrinsic functions in the WHERE clause
  3. Use SELECT * to include all fields

Question 24

Cloud Kicks would like to encrypt and store form data submitted from a CloudPage in a data extension using AMPscript. Which encryption option could be used?

  1. Symmetric
  2. SAML
  3. Asymmetric

Question 25

A developer wants a link to be dynamic based on subscriber attributes. Rather than create numerous links, the developer uses AMPscript to set the link's value as a variable. The variable will be used within the tag. What should the developer do within the tag to ensure clicks are tracked for the variable?

  1. Wrap the variable in a V function
  2. Wrap the variable in a RedirectTo function
  3. Include a variable for the Alias attribute