QUESTION 21
NTO uses data extensions to manage the subscriber information used for their email sends, and those sends includes calls to update records with new or different subscriber information. The developer handling these records writes some AMPscript to check and see if the data extension containing those records updated using an InsertDE() call if the record doesn’t yet exist. Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?

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

QUESTION 23
A developer is troubleshooting why a parent-level data extension cannot be accessed by a child business unit.
What should the developer check to validatethe data available can be accessed for child business unit queries?

QUESTION 24
A developer used LookupRowsto retrieve data when building a dynamic email.
What should be the next step before using this rowset within a FOR loop?

QUESTION 25
A developer needs to configure an Email Send Logging Data Extension for a new business unit. Which option should be used?

QUESTION 26
How can SSJS variables be referenced for content personalization? Choose 1.

QUESTION 27
A developer built a complex dynamic email with many data variants. Rather than create test data manually, they want to use a subset of live data to validate the dynamic aspects of the email.
Which SQL function should be used to collect a representative sample from a larger data set?

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

QUESTION 29
A developer is building an integration with the Marketing Cloud API. Which configuration should be used for the API integration component in the associated Installed Package?

QUESTION 30
A developer is using the REST Authorization Service to obtain an OAuth access token. Which method should be used to include the access token in the API requests

QUESTION 31
Landing pages can use which SSJS library? 1. Core LibraryZ. Platform Library 3. SSJS Library

QUESTION 32
Northern Trail Outfitters’ account is configured with two child BU(s): US and Global. The account has a dataextension 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 becreated 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 33
A developer wants to configure performance tracking of the content dynamically created via AMPscript in an email. Which two steps should be performed to achieve this objective? Choose 2

QUESTION 34
A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?

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

QUESTION 36
A developer is creating a CloudPage which accepts secure parameters via an email link and will submit those parameters to another CloudPage for data upsert. The page currently captures an Appointment ID parameter passed into it and sets the value to the variable caapptld. The developer does NOT want the Appointment ID to be visible to anyone using the form.
What is the best method to ensure the parameters are passed successfully to the data upsert page?

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

QUESTION 38
A developer wants to add an image to Content Builder via the API and retrieve the image’s published URL. Which method should the developer use?

QUESTION 39
A marketer is troubleshooting why an email send’s tracking information is not available in Sales Cloud. The marketer confirms MarketingCloud Connect is installed properly. What should be confirmed next to continue troubleshooting the send’s tracking information?

QUESTION 40
A developer is configuring a File Drop Automation and wants to use a Filename Pattern to allow for timestamps on the file. The file name will always start with the month and day (e.g. MAY15) the file is dropped onto the SFTP site.
Which two configurations should be used for the automation to successfully start? Choose 2 answers

QUESTION 41
A developer needs to add From Addresses to Marketing Cloud and wants to ensure they are verified before being used for sending.
Which tworoutes would allow this?
Choose 2 answers

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

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