NEW QUESTION 99
Northern Trail Outfitters has an Enterprise 2.0 account with 15 business units. Each business unit can access a Shared Data Extension named ‘Inventory’, which contains the details for each product. A Boolean field named ‘InStock’ indicates whether the item is available.
Which snippet of AMPscript would return all products which are currently available?

NEW QUESTION 100
NTO uses an external CRM which only exports encrypted files. NTO’s marketing manager team wants to use some of the subscriber data found in the CRM for future marketing sends. Which three actions should be included in an automation given thse requirements? Choose 3

NEW QUESTION 101
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 102
NTO is reconsidering the requirement to have English, Spanish and French versions of their email campaigns.
They request a developer to create a query which aggregates clicks grouped by language of the recipient.
Language is stored in a Profile Attribute.Which two Data Views would be included in the query? Choose 2 answer

NEW QUESTION 103
A developer wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include record which contain a phone number. Each of the following flieds contains this information per these rules: -Phone is not black (Data Type = Phone) -PhoneExist is true (Data Type = Boolean) -ValidPhone is ‘true’ (Data Type = Formula(Boolean)) -ContactType equals ‘Phone’ (Data Type = Text). Which field could be used to select a subset of records in the syncrhonization configuration?

NEW QUESTION 104
A developer identified duplicate contacts and initiated aContact Delete process for 10 million subscribers.
How could the process be expedited?

NEW QUESTION 105
A developer needs to configure a process that can store encrypted data from Marketing Cloud as a file on an external server. What steps should the developer take?

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

NEW QUESTION 107
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 108
Northern Trail Outfitters wants to trigger follow up messages after a subscriber opens an email.
What process would they use to get real-time engagement data?

NEW QUESTION 109
What is the purpose of the IF statement below?

NEW QUESTION 110
A developer is building an integration with the Marketing Cloud API. In which two ways should the Client ID and Client Secret credentials be stored? Choose 2

NEW QUESTION 111
A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

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

NEW QUESTION 113
When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?

NEW QUESTION 114
An email requires custom AMPscript to append the subscriber’s zip code to a link in the email. A field name zipcode already exist in the sending data extension. Its important Marketing Cloud tracks subscribers who click on the link. Which two AMPscript functions should be used in the setup? Choose

NEW QUESTION 115
A developer needs to write AMPscript to ensure the expiration date on a coupon is the last day of the month.
What would produce the desired result?

NEW QUESTION 116
Customer data has been imported into a staging data extension and needs to be normalized before adding into the master data extension. A text field named ‘birthday’ contains date values in various formats. Some of the values are valid dates, but some are not.
Which SQL keywords and functions could be used to write the query” Choose 2 answers

NEW QUESTION 117
A marketer from Cloud Kicks wants to make sure no email from their welcome journey gets sent to their competitor at Rainbow Run.
Which two best practices should the developer use when setting up the Send Email Activity in the welcome journey?
Choose 2 answers

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

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

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

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

NEW QUESTION 122
Certification Aid wants to add new customers to a cross-channel welcome campaign when they register on the company website. Which API should be used for this? Choose 1.

NEW QUESTION 123
A developer wants to upload a base64-encoded file to Content Builder using an API Installed Package but receives an insufficient Privileges error. What should the developer check to trobuleshoot the error?