NO.47 NTO wants to exclude sending an email at send time to those with a record on the ‘Exclude’ Data Extension.
The primary key on this data extension is Subscriber Key. How would a developer write the Exclusion Script?

NO.48 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

NO.49 A developer wants to personalize a welcome email with the recipient’s first name from the Customers data extension, which is different from the targeted sending data extension named NewSubscribers. Both data extensions contain the unique identifier in a field named CustomerKey. Which AMPscript Syntax would populate the first name personalization as requested?

NO.50 NTO wants to trigger a receipt email via the SOAP API whenever a customer makes a purchase. Their developer wrote the call using the TriggerSendDefinition object and the Create method, but no emails have been sent during his initial testing. Which object and method should the developer use?

NO.51 A developer is creating a custom preference center and wants to log unsubscribe events from the CloudPage. Which set of parameters should be captured and provided to the LongUnsubEvent Execute Call to ensure accurate unsubscribe information?

NO.52 A developer identified duplicate contacts and wants to delete roughly 10 million subscribers using Contact Delete. How could the process be expedited?

NO.53 A developer needs to identify all subscribers who were sent Job ID 420 but did not click any links. Which SQL statement would produce the desired results?

NO.54 Certification Aid sends an email to a newly imported List with Subscribers who have no associated Subscriber Key. Which value will become the Contact Key? Choose 1.

NO.55 A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscibers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension. Which best pratice should the developer follow to control the unique and default content?

NO.56 A developer wants to inject a Contact into a journey using API. What method and route would be used to accomplish this?

NO.57 Certification Aid created following AMPscript code: %%[ SET @var1 = 10 SET @var2 = 20 SET @var3 =
30 ]%% How can the three variables be summed up to evaluate to 60? Choose 1.

NO.58 A developer uses an API to send data to a Marketing Cloud data extension once every five minutes using the REST API. They notice data does not always write to the data extension, leading to data loss.
Which three best practices are recommended to avoid this issue? Choose 3 answers

NO.59 What is the operational order of the Contact Delete process for Marketing Cloud?

NO.60 NTO is using an asynchronous SOAP API call to the TriggerSend object to send order confirmation email to their customers. Which API object and attribute should be used to retrieve the status of the API call?

NO.61 A developer is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?

NO.62 A field value returned from a DE lookup contains a tab-delimited list of values. Which AMPscript function could easily determine if a specific text string exist anywhere in the list?

NO.63 * 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.

NO.64 Where can the SSJS Core library be used? Choose 2.

NO.65 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 subsceriber submits the form?

NO.66 Certification Aid wants to include SSJS in an email message. Which code block can be used for this? Choose 2.