Certification Aid uses Marketing Cloud Connect and wants to create a lead capture form on a landing page. When a customer submits the form, a Lead record should be created in Salesforce. Which scripting language can be used for this? Choose 2.
A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?
Northern Trails Outfitters (NTO)has a sendable data extension with 1,500,000 contact records they want to delete.
Which step is required before deleting the contacts?
A developer is querying data from the _Bounce data view and storing it in a data extension. They have found that sometimes the fields SMTPBounceReason and SMTPCode exceed the 4000-character limits for each field as specified in the DE schema. After consulting with the original requestor, it was decided that they could simply store the first 4000 characters for each of those fields.
Which SQL function could be used for this purpose?