NEW QUESTION 20
Certification Aid wants to import data from a CSV file into a Data Extension. The CSV file contains all relevant dat a. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

NEW QUESTION 21
A developer is writing a query to select unique subscribers who opened any emails sent since the beginning of the previous day.
Which query would provide that result?
A)

B)

C)

NEW QUESTION 22
A developer wants to use the RaiseError Ampscript function when a subscriber does not have the necessary data to build an email. Which two outcomes are possible using this function? Choose 2 answer

NEW QUESTION 23
A developer needs to use the ‘contacts/ route of the REST API to update records in a data extension.
What should the developer verify before making the API call?

NEW QUESTION 24
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.

NEW QUESTION 25
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

NEW QUESTION 26
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?

NEW QUESTION 27
A developer needs to find all subscribers on the Customers data extension who made a purchase in the last 30 days. Purchase data is on the Orders data extension which contains a column called ‘PurchaseDate’. Contacts are identified in both data extensions by a column called ‘ContactKey’, and the Orders data extension can contain many instances of the same subscnber.
Which SQL keyword should the developer use to achieve the desired result?

NEW QUESTION 28
A developer wants to populate a data extension with information about all emails deployed in the last seven days. The data extension needs to contain JobID, EventDate, and the counts of how many emails were sent with each JobID.
Which data view is required to gather this information?

NEW QUESTION 29
Contact Builder can be used to create a relational model of an organization’s data within Marketing Cloud. Which three factors should be taken into consideration when preparing data to be used in Contact Builder? Choose 3 answer

NEW QUESTION 30
A developer receives Error Code 5 when performing a SOAP API call. The error states: “Cannot Perform ‘Post’ on objects of type ‘SentEvent'”.
What could be the issue?

NEW QUESTION 31
NTO wants use Personally Identifiable Information (PII) data to personalize email communications, but does not want to store PII data in Marketing Cloud. Which feature could they use to personalize emails from an external data source?

NEW QUESTION 32
Northern Trails Outfitters (NTO) developers want to use the Transactional Messaging API to send email receipts to customers.
What is the first step required to send using the API?

NEW QUESTION 33
A developer identified a use case where a triggered send of an email is needed. The developer already successfully set up authentication with a Client ID and Client Secret has used them in several REST calls. When the REST call is made, a “401 Unauthorized” error is returned. What is the first thing the developer should check?

NEW QUESTION 34
A developer needs to determine why a Query Activity in an Automation has failed.
Which three scenarios could have caused this? Choose 3 answers

NEW QUESTION 35
Which action could the RaiseError AMPscript function be configured to perform?

NEW QUESTION 36
A developer is using the legacy endpoint www.exacttargetapis.com and has been asked to switch to Tenant Specific Endpoints (TSEs). What is a benefit of switching to TSEs?

NEW QUESTION 37
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?

NEW QUESTION 38
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?