QUESTION 88
NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?

QUESTION 89
Certification Aid wants to update Contact data stored in a Data Extension using the REST API. What is required to achieve this? Choose 1.

QUESTION 90
A developer wants to include a comment within an AMPscript code block for the benefit of other developers who will be reviewing the code.
Which syntax should the developer use?

QUESTION 91
A company need to retrieve a large number of rows from a DE via the API. Which two solutions would optimize the peformance? Choose 2

QUESTION 92
Certification Aid wants to add records to a Data Extension using the SOAP API. Which object can be used for this? Choose 1.

QUESTION 93
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.

QUESTION 94
Which activity is required before a compressed file can be imported?

QUESTION 95
A developer receives a 401 Unathorized HTTP status message from a REST API request. What is the reason for this error?

QUESTION 96
A developer wants to design a custom subscription center in CloudPages. The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience. Which feature should handle this scenario?

QUESTION 97
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?

QUESTION 98
How many month of data can a developer query from the tracking data views (_Sent, _Open, _Click)?

QUESTION 99
A developer wants to build an email that dynamically populates the physical address of a company’s locations using the variable @address. The deployment goes to millions of subscribers and the developer wants the fastest possible performance.
Which AMPscript solution should be recommended?

QUESTION 100
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

QUESTION 101
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 SubsciberKey. How would a developer write the Exclusion Script?

QUESTION 102
A developer receives a 401 Unathorized HTTP status message from a REST API request. What is the reason for this error?

QUESTION 103
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 subscribers 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 practice should the developer follow to control the unique and default content?

QUESTION 104
A developer wants to design a custom subscription center in CloudPages.The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience. Which feature should handle this scenario?

QUESTION 105
Northern Trail Outfitters’ account is configured with two child BU(s): US and Global. The account has a data extension In the Shared Data Extensions folder named ‘MemberData’. This data extension contains basic address information, as well as Boolean fields labeled ‘US’ and ‘Global’ indicating to which business unit the subscriber belongs. Automation needs to be created in the US business unit to query all records in New York who are members of the business unit US.
SELECT * FROM MemberData WHERE State = ‘NY’ AND US = 1
What would cause this query to report the following error: “An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views.”?

QUESTION 106
What is the purpose of the IF statement below?

QUESTION 107
Northern Trail Outfitters uses a Send Log and sends more than one million emails per day. They want to execute daily reports on all subscriber activity without impacting send performance.
Which set of best practices should be implemented”

QUESTION 108
Northtrn Trail Outfitters (NTO) wants to import a data file. It will be uploaded at regular intervals to their Enhanced FTP Account where an automation will import the file Into a data extension. NTO requires the file to be encrypted.
Which two file encryption options are supported when importing data files to Marketing Cloud?
Choose 2 answers

QUESTION 109
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 110
Which SSJS library can be used in email messages? Choose 1.

QUESTION 111
How can subscriber, system, and sendable Data Extension attributes be referenced for content personalization using SSJS? Choose 1.

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